Syntax Highlighter

(Date1 as date , Date2 as date) =>
let
    Source =
        List.Generate(
            () => [x = 1, y = Date.AddMonths(Date1,x)],
            each [y] <= Date2,
            each [x = [x] + 1, y = Date.AddMonths(Date1,x)],
            each [y]
        ),
    Months = List.Count(Source)
in
    Months

something?


(Date1 as date , Date2 as date) =>

Something in between


let
    Source = Excel.Workbook(File.Contents("C:\Example.xlsx"), null, true)
in
    Source

Scroll to Top