Calculating year over year change in % for MTD Sales

[Mohanad-Mustafa]

Hi Team,

I have created these three forumlas to calculate my MTD for 2021,2020 and 2019 respectively and they work well. 

I have used all these filters because my calendar table is a bit complicated. 

MTD 2021 = CALCULATE(SUM(Sales[Total Sales]), FILTER('Calendar','Calendar'[Date] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 01)), FILTER('Calendar', 'Calendar'[Date] < TODAY()-1))

MTD 2020 = CALCULATE ( SUM ( Sales[Total Sales] ), FILTER ( 'Calendar', 'Calendar'[Date] >= DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), 01 ) ), FILTER ( 'Calendar', 'Calendar'[Date] < DATE ( YEAR ( TODAY () ) -1, MONTH ( TODAY () ), DAY ( TODAY () ) ) ) )

MTD 2019 = CALCULATE ( SUM ( Sales[Total Sales] ), FILTER ( 'Calendar', 'Calendar'[Date] >= DATE ( YEAR ( TODAY () ) - 2, MONTH ( TODAY () ), 01 ) ), FILTER ( 'Calendar', 'Calendar'[Date] < DATE ( YEAR ( TODAY () ) -2, MONTH ( TODAY () ), DAY ( TODAY () ) ) ) )

Now I need to calculate the change for percentage between the MTD measures for the three years.

Is there a way to do this?

Thanks

Mohanad

[amitchandak]

@Mohanad-Mustafa , with help from datesmtd

measures example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

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

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

refer if needed

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

[Mohanad-Mustafa · Accepted solution]

Thanks @amitchandak , I found another solution to calculate MTD year over year percentage. 

Solution is: 

MTD Change%(2020/2021) = ([MTD 2021]-[MTD 2020])/[MTD 2020]