Specific dates to extract from those available in dataflow, today and 7 days prior

[DamianKelly]

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? 

[watkinnc]

= Table.SelectRows(PriorStepOrTableName, each [Date] = Date.AddDays(Date.From(DateTime.LocalNow()), -7 ) or [Date] = Date.From(DateTime.LocalNow()))

--Nate

[DamianKelly]

Oh wow, that did it thank you so much!

[Greg_Deckler]

@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"