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]

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    #date(Date.Year(DateTime.LocalNow()),Date.Month(DateTime.LocalNow()),Date.Day(DateTime.LocalNow())) - [Date]
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

       

      Thanks!