I Need help on creating DAX or any other approach for getting last 3 months separately dynamically

[azeenk]

Dear Team,

I am currently developing three dynamic donut charts in Power BI to display data for the last three completed months. These charts will automatically update each month. For example:

• April: Charts will display data for January, February, and March.

• May: Charts will update to show February, March, and April.

Each chart will be filtered to its respective month, formatted as MMM_yyyy (e.g., Jan_2025), ensuring consistency and clarity.

Please let me know if you have any preferences or additional requirements for these visuals.

Best regards,
Hk

[v-sdhruv]

Hi @azeenk ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @azeenk ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @azeenk ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv · Accepted solution]

Hi @azeenk ,
You can make use of relative date slicer or relative date filter in Power BI for this.
This way you can achieve your results dynamically.

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Or you can simply apply visual level filter for these two charts.
1. April : Apply Jan,Feb and March
2. May : Apply Feb, march, April

Hope this helps!