how to differentiate same month previous and current year ?

[Anonymous]

i have a three years of data 2019,2010,2021

i want  differentiate  current month and same month last year 

Period       value 

Jan-21       1 25

Feb-21        225

Mar-21       225

April-21      325

May-21      425

Jun -21      525

July -21      325

August-21  525

Period       value 

Jan-20        265

Feb-20        525

Mar-20       425

April-20      325

May-20      225

Jun -20       125

July -20      325

August-20  125

i want differentiation percentage value 

Like current month  and  last year same month 

i am taking  current month and  same month last year

August -21    525

August -20    125

=(August21-august20)/august20

how to create a measure for same month  and last year same month value differentiate ? thanks in advance 

[AlexisOlson]

Assuming you have a proper calendar date table, DAX Patterns is a good resource for this kind of thing:
https://www.daxpatterns.com/standard-time-related-calculations/

[Anonymous]

@amitchandak thank you  sir let me check 

[amitchandak · Accepted solution]

@Anonymous , If you do not date in you table, create one using mon year. and then try time intelligence

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)))
Previous year Month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth(dateadd('Date'[Date],-11,MONTH)))

Take a diff

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