Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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 >= is because if I only use = it only brings back 'today' at that date but 12am.
also if I select past 7 days it does not include today....
Today the query is
= Table.SelectRows(Source, each Date.IsInPreviousNDays([datetime], 7) or [datetime] >= #datetime(2022, 8, 29, 0, 0, 0))
I have tried to use:
= Table.SelectRows(Source, each Date.IsInPreviousNDays([datetime], 7) or [datetime] >= #datetime(DateTime.LocalNow()))
but that didnt work. How can I dynammically change the date to be today and the previous 7 days.
try DateIsInPreviousDay + in previous (number of days you want to go back) days
OR
DateIsInPreviousDay + in next 24 + Hours
Unfortunately Date.IsInPreviousNDays does not include the date of today. The image on this page illustrates this: https://powerquery.how/date-isinpreviousndays/
You could use:
Table.SelectRows(
Source,
each [datetime] >= Date.AddDays( DateTime.LocalNow(), -7 )
and [datetime] <= DateTime.LocalNow()
)
Notice that even if you subtract days from a datetime value, the output is still a datetime value (https://powerquery.how/date-adddays/).
--------------------------------------------------
@ me in replies or I'll lose your thread
Master Power Query M? -> https://powerquery.how
Read in-depth articles? -> BI Gorilla
Youtube Channel: BI Gorilla
If this post helps, then please consider accepting it as the solution to help other members find it more quickly.
Use
Date.IsInCurrentDay(Date.From([datetime]))
Hence use this
= Table.SelectRows(Source, each Date.IsInPreviousNDays([datetime], 7) or Date.IsInCurrentDay(Date.From([datetime])))
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.