Forum Discussion

DamianKelly's avatar
DamianKelly
Frequent Visitor
2 years ago

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

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? 

 

 

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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"
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

     

    --Nate