//Create Date Dimension(StartDate as date, EndDate as date)=>let //Capture the date range from the parameters StartDate = #date(Date.Year(StartDate), Date.Month(StartDate), Date.Day(StartDate)), EndDate = #date(Date.Year(EndDate), Date.Month(EndDate), Date.Day(EndDate)),//Get the number of dates that will be required for the table GetDateCount = Duration.Days(EndDate - StartDate),//Take the count of dates and turn it into a list of dates GetDateList = List.Dates(StartDate, GetDateCount, #duration(1,0,0,0)),//Convert the list into a table DateListToTable = Table.FromList(GetDateList, Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error),//Create various date attributes from the date column //Add Year Column YearNumber = Table.AddColumn(DateListToTable, "Year", each Date.Year([Date])),//Add Quarter Column QuarterNumber = Table.AddColumn(YearNumber , "Quarter", each "Q" & Number.ToText(Date.QuarterOfYear([Date]))),//Add Week Number Colu
date/StartDate/EndDate/Date/Date.Year/dates/Quarter/Table.AddColumn/Year/GetDateList/
date/StartDate/EndDate/Date/Date.Year/dates/Quarter/Table.AddColumn/Year/GetDateList/
-->