Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Evening,
I've follow the guides to setup a Date Table using powerquery and it works perfectly.
let Source = #date(2010, 1, 1), Custom1 = List.Dates(Source, Number.From(DateTime.LocalNow())- Number.From(Source) ,#duration(1,0,0,0)), #"Converted to Table" = Table.FromList(Custom1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
I was wondering how to change it from simply creating the DateTable "DateTime.LocalNow()" until today, but until say for example the 1/1/2018 instead.
Thoughts on the powerquery code?
Solved! Go to Solution.
Just replace DateTime.LocalNow() by #date(2018,1,1).
Alternative code:
let Source = Table.FromColumns({{Number.From(#date(2017,1,1))..Number.From(#date(2018,1,1))}}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}) in #"Changed Type"
Just replace DateTime.LocalNow() by #date(2018,1,1).
Alternative code:
let Source = Table.FromColumns({{Number.From(#date(2017,1,1))..Number.From(#date(2018,1,1))}}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}) in #"Changed Type"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |