let
Source = Financials,
MinDate = Date.From(List.Min(Source[Date])),
MaxDate = Date.From(List.Max(Source[Date])),
DateList = List.Dates(
MinDate,
Duration.Days(MaxDate — MinDate) + 1,
#duration(1, 0, 0, 0)
),
DateTable = Table.FromList(DateList, Splitter.SplitByNothing(), {“Date”}),
AddYear = Table.AddColumn(DateTable, “Year”, each Date.Year([Date]), Int64.Type),
AddMonthNum = Table.AddColumn(AddYear, “Month Number”, each Date.Month([Date]), Int64.Type),
AddMonthName = Table.AddColumn(AddMonthNum, “Month Name”, each Date.MonthName([Date]), type text),
AddQuarter = Table.AddColumn(AddMonthName, “Quarter”, each “Q” & Number.ToText(Date.QuarterOfYear([Date])), type text),
AddDay = Table.AddColumn(AddQuarter, “Day”, each Date.Day([Date]), Int64.Type)
in
AddDay