Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Get data for the last X days including today

I am trying to get data for the past 7 days including today I have tried in the previous 7 days and selecting 'today' (see img) but the next day it does not dynamically change.  The reason I am using...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Use

Date.IsInCurrentDay(Date.From([datetime]))

Hence use this

= Table.SelectRows(Source, each Date.IsInPreviousNDays([datetime], 7) or Date.IsInCurrentDay(Date.From([datetime])))