Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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])))