let
  Source = Sql.Database("Server", "Database"), 
  sql = Value.NativeQuery(
    Source, 
    "SELECT *,
            SUM(Price) OVER (PARTITION BY ProductID ORDER BY Date, RN) as RT 
    FROM
        dbo.Table", 
    null, 
    [EnableFolding = true]
  )
in
  sql

let
  Source = Sql.Database("Server", "Database"), 
  sql = Value.NativeQuery(
    Source, 
    "SELECT *,
            SUM(Price) OVER (PARTITION BY ProductID ORDER BY Date
                             ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as RT
    FROM
        dbo.Table", 
    null, 
    [EnableFolding = true]
  )
in
  sql

let
  Source = Sql.Database("Server", "Database"), 
  sql = Value.NativeQuery(
    Source, 
    "SELECT *,
            SUM(Price) OVER (PARTITION BY ProductID ORDER BY Date) as RT 
    FROM
        dbo.Table", 
    null, 
    [EnableFolding = true]
  )
in
  sql

= CELL("filename";A1)

= ЯЧЕЙКА("имяфайла";A1)

let
    Source = Excel.CurrentWorkbook(),
    filename = Source{[Name="filename"]}[Content],
    path = let a = Text.SplitAny(filename{0}[Column1],"[]") in a{0} & a{1}
in
    path

Source = Excel.Workbook(File.Contents(path))

=LET(a; CELL("filename";A1); b; SEARCH("[";a); LEFT(a;b-1))

if x = null then 0 else x

x ?? 0

let
  Source = data,
  cols = List.Buffer(List.Skip(Table.ColumnNames(Source))),
  final = Table.TransformColumns(
    Table.SelectRows(Source, each [#"TRUE/FALSE"]),
    List.Transform(cols, (x) => {x, each _ * 10})
  )
    & Table.TransformColumns(
      Table.SelectRows(Source, each not [#"TRUE/FALSE"]),
      List.Transform(cols, (x) => {x, each _ * 20})
    )
in
  final

let
  Source = data,
  i = Table.AddIndexColumn(Source, "i"),
  cols = List.Buffer(List.RemoveItems(Table.ColumnNames(i), {"TRUE/FALSE", "i"})),
  transform = Table.TransformColumns(
    Table.SelectRows(i, each [#"TRUE/FALSE"]),
    List.Transform(cols, (x) => {x, each _ * 10})
  )
    & Table.TransformColumns(
      Table.SelectRows(i, each not [#"TRUE/FALSE"]),
      List.Transform(cols, (x) => {x, each _ * 20})
    ),
  final = Table.RemoveColumns(Table.Sort(transform, {"i", 0}), "i")
in
  final

(tbl, col, n)=>
let
    z = Table.RenameColumns(tbl,{col,"Свойство"})
in
    Table.ReplaceValue(z,"*",")",(a,b,c)=>b & {"Нет","Да"}{Number.From(a > n)} & c, {"Свойство"})

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица2"]}[Content],
    cols = Table.ColumnNames(Source),
    f = (l,n)=>List.RemoveLastN(l,n),
    x = Record.ToList(Source{0}),
    list = f(f(x, each _ = null),1),
    result = #table(cols,{}) & #table(List.FirstN(cols,List.Count(list)),{list})
in
    result

ForSorting = DIVIDE(1,YEAR('Calendar'[Date]))

=
CALCULATE (
    SUM ( Data[Сумма] );
    EXCEPT (
        VALUES ( Data[Клиент] );
        CALCULATETABLE (
            VALUES ( Data[Клиент] );
            Data[Заказчик] = "A"
                || Data[Заказчик] = "D"
        )
    )
)

PercOnParent = 
VAR CurrentSales = [SalesAmount]
VAR TradeMarkSales =
    CALCULATE ( [SalesAmount], ALLSELECTED ( 'Товар'[Наименование товара] ) )
VAR RetailChainSales =
    CALCULATE ( [SalesAmount], ALLSELECTED ( 'ТМ'[Торговая Марка] ) )
VAR TotalSales =
    CALCULATE ( [SalesAmount], ALLSELECTED ( 'Магазин'[Сеть] ) )
VAR RatioToParent =
    IF (
        ISINSCOPE ( 'Товар'[Наименование товара] ),
        DIVIDE ( CurrentSales, TradeMarkSales ),
        IF (
            ISINSCOPE ( 'ТМ'[Торговая Марка] ),
            DIVIDE ( CurrentSales, RetailChainSales ),
            IF ( ISINSCOPE ( 'Магазин'[Сеть] ), DIVIDE ( CurrentSales, TotalSales ) )
        )
    )
RETURN
    RatioToParent

let
  Source = Excel.CurrentWorkbook(){[Name = "Data"]}[Content],
  age = Table.AddColumn(
    Source,
    "Age",
    each 
      let
        a = DateTime.FixedLocalNow(),
        b = [Дата рождения2],
        c = Date.Year(a) - Date.Year(b)
      in
        c - Number.From(a < Date.AddYears(b, c))
  ),
  rec = [
    #"до 16"       = {1 .. 15},
    #"от 16 до 24" = {16 .. 23},
    #"от 24 до 35" = {24 .. 34},
    #"от 35 до 50" = {35 .. 49},
    #"от 50"       = {50 .. 969}
  ],
  tbl = Table.ExpandListColumn(Table.RenameColumns(Record.ToTable(rec), {"Value", "Age"}), "Age"),
  join = Table.Join(age, "Age", tbl, "Age"),
  sort = Table.Sort(join, {"ID", 0})
in
  sort

&{0}

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    unpivot = Table.UnpivotOtherColumns(Source, {"Клиент"}, "Атрибут", "Сумма"),
    split = Table.SplitColumn(unpivot, "Атрибут", (x)=>let a = if Text.StartsWith(x,"Д") then "Доход" else "Расход" in {a, Text.Split(x,a){1}}, {"Тип", "Продукт"}),
    pivot = Table.Pivot(split, List.Distinct(split[Тип]), "Тип", "Сумма"),
    replace = Table.ReplaceValue(pivot,null,0,Replacer.ReplaceValue,{"Доход","Расход"}),
    add = Table.AddColumn(replace, "Доход - Расход", each List.Sum({[Доход],[Расход]})),
    add1 = Table.AddColumn(add, "Расход/Доход", each [Расход]/[Доход]),
    unpivot1 = Table.UnpivotOtherColumns(add1, {"Клиент", "Продукт"}, "Атрибут", "Сумма"),
    merge = Table.CombineColumns(unpivot1,{"Атрибут","Продукт"},Text.Combine,"temp"),
    pivot1 = Table.Pivot(merge, List.Distinct(merge[temp]), "temp", "Сумма")
in
    pivot1

let
    Source = Record.ToTable([name1={[a="aa1",c="cc1",z="zz1"],[a="aa2",c="cc2",z="zz2"],[a="aa3",c="cc3",z="zz3"]},
                             name2={[a="aa3",c="cc3",z="zz3"]},
                             name3={[a="aa1",c="cc1",z="zz1"],[a="aa3",c="cc3",z="zz3"]}]),
    n=1, //заранее известный порядковый номер искомого поля в записи (нумерация с нуля)
    transform = Table.TransformColumns(Source, {"Value", each Table.Transpose(Table.FromRecords(_)){n}}),
    expand = Table.ExpandRecordColumn(transform, "Value", List.Union(List.Transform(transform[Value], Record.FieldNames)))
in
    expand