=ПОИСК("3.141529";Ф.ТЕКСТ(D2))

    spis= #table(type table [Date = date], List.Zip({List.Dates(#date(2020,1,1),1+Number.From(#date(2020,3,1)-#date(2020,1,1)),#duration(1,0,0,0))})),
    Type = Table.TransformColumnTypes(result,{{"Даты", type date}}),
    Merge = Table.Join(spis,{"Date"},Type,{"Даты"},JoinKind.LeftOuter),
    Remove = Table.RemoveColumns(Merge,{"Даты"})
in
    Remove

let
    Источник = Excel.CurrentWorkbook(),
    Filter = Table.SelectRows(Источник, each not Text.Contains([Name], "Сводная")),
    #"Removed Other Columns" = Table.Combine(Table.SelectColumns(Filter,{"Content"})[Content]),
    #"Grouped Rows" = Table.Group(#"Removed Other Columns", {"Даты"}, {{"сумма", each List.Sum([Столбец1]), type number}, {"сумма2", each List.Sum([Столбец2]), type number}}),
    #"Sorted Rows" = Table.Sort(#"Grouped Rows",{{"Даты", Order.Ascending}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Sorted Rows",{{"Даты", type date}})
in
    #"Changed Type"

let
    Source = {
              "https://www.walmart.ca/en/ip/coffee-table/6000199157960",
              "https://www.walmart.ca/en/ip/coffee-table-rustic-oak/6000199108427",
              "https://www.walmart.ca/en/ip/coffee-table-canyon-walnut/6000199107072",
              "https://www.walmart.ca/en/ip/coffee-table-espresso/6000199217059",
              "https://www.walmart.ca/en/ip/coffee-table/6000199156809"},
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing()),
    #"Added Custom" = Table.AddColumn(#"Converted to Table", "Цена", each let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents([Column1]))}),
    Insert = Table.AddColumn(Source, "a", each Text.BetweenDelimiters([Column1], """upc"":[""", """]"), type text),
    Filter = Table.SelectRows(Insert, each   [a] <> "")[a]{0},
    Custom1 = Json.Document(Web.Contents("https://www.walmart.ca/api/product-page/find-in-store?latitude=48.4120872&longitude=-89.2413988&lang=en&upc="&Filter)),
    info = Custom1[info],
    info1 = info{0}[sellPrice]
in
    info1)
in
    #"Added Custom"

=СУММ(ИНДЕКС(ЕСЛИ((B4:H4>=ПОИСКПОЗ(K1;B4:H4;))*(B4:H4<=ПОИСКПОЗ(L1;B4:H4;));B5:H14);ПОИСКПОЗ(M3;A5:A14;)))

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    Add = Table.AddColumn(Source, "Столбец3", each Source[Столбец2])[[Столбец1],[Столбец3]],
    Exp = Table.ExpandListColumn(Add, "Столбец3")
in
    Exp

=МИН(ЕСЛИ(H3:H8>=D3;H3:H8))

= Expression.Evaluate("expressionTable[["&Text.Combine(Table.ColumnNames(Source)&{"Результат"},"],[")&"]]", [expressionTable=result])
= Table.SelectColumns(result,Table.ColumnNames(Source)&{"Результат"})

= Table.AddColumn(join, "Результат", each if [Столбец] <> null then Record.FieldOrDefault(_, [Столбец],
 "что-то пошло не так ☹") else null) и "[["&Text.Combine(Table.ColumnNames(Source)&{"Результат"},"],[")&"]]"

=МАКС(ЕСЛИ(B2:B7=1;A2:A7))

let Подмена = Table.Buffer(Excel.CurrentWorkbook(){[Name="Подмена"]}[Content]),
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content]
in Table.AddColumn(Source, "Result", each try Record.FieldOrDefault(_, Table.Join
(Record.ToTable([[Клиент]]),  {"Value"},Подмена,{"Что ищем"},1)[Столбец]?{0}?) otherwise null)

let
    Source = Folder.Files("C:\abc\xml\xml"), end = Table.AddColumn(
    Source, "CadastralNumber", each Xml.Tables([Content])[Table]{1}
    [Table]{1}[Table]{1}[ObjectRight]
    {0}[ObjectDesc]{0}[CadastralNumber]{0})[[Name],[CadastralNumber]]
in
    end

или так


let
    Source = Folder.Files("C:\abc\xml\xml"),
    Add = Table.AddColumn(Source, "CadastralNumber", each
     let
       Source = Table.FromColumns({Lines.FromBinary([Content])}),
       Filtr = Table.SelectRows(Source, each Text.Contains([Column1]
       , "<CadastralNumber>")),Extrc = Table.TransformColumns(Filtr,
      {{"Column1", each Text.BetweenDelimiters(_, ">", "</")}}){0}[Column1]
     in
       Extrc)[[Name],[CadastralNumber]]
in
    Add