Calendar vs Calender Auto vs Power Query Dim Date

Описание к видео Calendar vs Calender Auto vs Power Query Dim Date

let
Source = "",
StartDate_ = #date(2022, 1, 1),
CurrentDate = DateTime.Date( DateTime.FixedLocalNow()),
LastDate_ = Date.EndOfYear( DateTime.Date( DateTime.FixedLocalNow())),
List = List.Dates(StartDate_ ,Number.From(LastDate_ - StartDate_), #duration( 1 , 0 ,0 ,0)),
#"Converted to Table" = Table.FromList(List, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Date"}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}}),
#"Sorted Rows" = Table.Sort(#"Changed Type1",{{"Date", Order.Descending}}),
#"Inserted Year" = Table.AddColumn(#"Sorted Rows", "Year", each Date.Year([Date]), Int64.Type),
#"Inserted Month" = Table.AddColumn(#"Inserted Year", "Month", each Date.Month([Date]), Int64.Type),
#"Inserted Quarter" = Table.AddColumn(#"Inserted Month", "Quarter", each Date.QuarterOfYear([Date]), Int64.Type),
#"Inserted Merged Column" = Table.AddColumn(#"Inserted Quarter", "Merged", each Text.Combine({"Q", Text.From([Quarter], "en-US")}), type text),
#"Renamed Columns1" = Table.RenameColumns(#"Inserted Merged Column",{{"Merged", "Quarter Name"}})
in
#"Renamed Columns1"


---------------------------

Calendr = CALENDAR(MIN(Test_All[Date]),MAX(Test_All[Date]))

Комментарии

Информация по комментариям в разработке