Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm really hoping someone can help this Power BI novice! A colleague of mine kindly created a data-set, where one of the dataflows has +30days of data within it (so extracted daily, over 30 days). But he set it up to only pull the latest date on background refresh, i.e. today, so each morning the latest date is the only data extracted.
What I'd like to do is actually pull two dates from the +30 days available, so today's data and relative to that, seven days prior i.e. same day last week's data.
Found this for the -7
= Date.AddDays(Date.From(DateTime.LocalNow()), -7 )
This for the today
= Date.From(DateTime.LocalNow())
How do I combine? So I get both dates?
= Table.SelectRows(PriorStepOrTableName, each [Date] = Date.AddDays(Date.From(DateTime.LocalNow()), -7 ) or [Date] = Date.From(DateTime.LocalNow()))
--Nate
Oh wow, that did it thank you so much!
@DamianKelly Here is one way:
let
Source = { Date.AddDays(Date.From(DateTime.LocalNow()), -7 ), Date.From(DateTime.LocalNow()) },
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"