星型模式电源双中的日历表

我有这张图片

https://oxcrx34285.i.lithium.com/t5/image/serverpage/image-id/209632iCA1E2E411DA5480C/image-size/large?v=1.0&px=999

我希望所有这些都在表中。我尝试了几个,但没有得到别人的帮助

    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"
bhc2955 回答:星型模式电源双中的日历表

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3081885.html

大家都在问