Current Day Offset

[Anonymous]

Hello All,

I have a report where I need to filter by -3 days and +12 days to todays date. It needs to consistently update. If possible, I'd prefer to have this in Power Query.

Thanks!

[Greg_Deckler]

In DAX it would be:

(TODAY() - [Date]) * 1.

[Anonymous]

Oh... 😶 Maybe I'll just do it in DAX then.

Thanks!

[Greg_Deckler · Accepted solution]

#date(Date.Year(DateTime.LocalNow()),Date.Month(DateTime.LocalNow()),Date.Day(DateTime.LocalNow())) - [Date]