我有这张图片
我希望所有这些都在表中。我尝试了几个,但没有得到别人的帮助
let
Source = List.Dates( Date.FromText("1996-01-01"),Number.From(Date.FromText("2018-01-01")) - Number.From(Date.FromText("1996-01-01")) +1,#duration(1,0)),#"Converted to Table" = Table.FromList(Source,Splitter.SplitByNothing(),null,ExtraValues.Error),#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1",type date}}),#"Year" = Table.AddColumn(#"Changed Type","Year",each Date.Year([Column1])),#"Month" = Table.AddColumn(#"Year","Month",each Date.Month([Column1])),#"Quarter" = Table.AddColumn(#"Month","Quarter",each Date.QuarterOfYear([Column1])),#"Month Name" = Table.AddColumn(#"Quarter","Month Name",each Date.MonthName([Column1]),type text),#"Day Name" = Table.AddColumn(#"Month Name","Day Name",each Date.DayOfWeekName([Column1]),type text)
in
#"Day Name"