Clivela

  New Blank Query In advanced Editor Rename query to "fxRuningTotal" Go to table query Advanced Editor

 let fnDateTable = (StartDate as date, EndDate as date, FYStartMonth as number) as table =>   let     DayCount = Duration.Days(Duration.From(EndDate - StartDate)),     Source = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),     TableFromList = Table.FromList(Source, Splitter.SplitByNothing()),        ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", type date}}),     RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}),     InsertYear = Table.AddColumn(RenamedColumns, "Year", each Date.Year([Date]),type text),     InsertYearNumber = Table.AddColumn(RenamedColumns, "YearNumber", each Date.Year([Date])),     InsertQuarter = Table.AddColumn(InsertYear, "QuarterOfYear", each Date.QuarterOfYear([Date])),     InsertMonth = Table.AddColumn(InsertQuarter, "MonthOfYear", each Date.Month([Date]), type text),     InsertDay = Table.AddCo...