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)...
Need Help
Tips and Tricks
Tutorial Requests
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"