Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Current Day Offset

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!
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    #date(Date.Year(DateTime.LocalNow()),Date.Month(DateTime.LocalNow()),Date.Day(DateTime.LocalNow())) - [Date]
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

In DAX it would be:

 

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Oh... ðŸ˜¶ Maybe I'll just do it in DAX then.

 

Thanks!