how to make a filter for last month which work for last year as well for same month in previous year

[Ramendra]

Hi Team,

I need a filter where I  can select the filter like previous month but it  should work for this year as well as for last year.

For  example if  I have data for this year  and last year and I want to show the count of tickets brocken by priority for previous month ( April-2020 and April 2021) then how to create such filter.

Can someone please  help me.

[negi007 · Accepted solution]

@Ramendra Hi Ram, in this case i would suggest you to create seperate measure to calculate value for previous year. So when you select April month, it will show the data for both previous year and current year

Sales_PY = CALCULATE(SUM('Sales),SAMEPERIODLASTYEAR('Data'[Date].[Date]))

[amitchandak]

@Ramendra , Create two measures

last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

if you want to switch, you can use measure slicer

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...