Forum Discussion

dgilm33's avatar
dgilm33
Helper I
4 years ago
Solved

Dynamic Date Range

Hi everyone,

 

I'm still learning Power Bi so this may be a simple solution, but I have a report where I'm using DateTime.LocalNow() so the report shows the last refresh date on the date the report is refreshed. I also have a date range to show what data is included in the report. The date range is 3 months behind the current date (so refreshing today would show 3/29/2022 and a date range of 01/01/2021-12/31/2021). Currently the date range has to be updated manually every month. I'm wanting to make this dynamic so when the report is refreshed in April I won't have to manually go in and update the date range. I'm having trouble figuring out a dynamic way to show the rolling 12 months 3 months behind, while keeping the range between the first and late day of the month. Below may help in what I'm looking to do:

 

Thank you for any help you can give!

  • dgilm33 

    is this what you want?

    Date Range = 
    EOMONTH('Table'[Current Date],-15)+1 &"-"& EOMONTH('Table'[Current Date],-3)

1 Reply

  • dgilm33 

    is this what you want?

    Date Range = 
    EOMONTH('Table'[Current Date],-15)+1 &"-"& EOMONTH('Table'[Current Date],-3)