Previous year and current year Comparision percentage

[Anonymous]

i have three year wise data compare current month and previous month calculations 

I have  data like below 

Period              Revised closing value

1-4.2019                     56
1-4.2019                     66

1-5.2019                    77

1-5.2019                    45

1-5.2019                    45

1-6.2019                  34

1-6.2019                  34

1-7.2019                  56
1-8.2019                   66

1-9.2019                   77

1-9.2019                   45

1-10.2019                 45

1-11.2019                 34

1-12.2019                 34

1-1.2020                   56
1-2.2020                   66

1-3.2020                   77

1-4.2020                   45

1-5.2020                   45

1-6.2020                   34

1-6.2020                   34

i want current year value  and previous year  percentage value 

i have tired below measure but now wokring getting blank value

%Prvs = VAR LastMAXDate = MAX ( Data[Period] )

var currentvalue = CALCULATE (

SUM ( Data[Revised closing value] ),

Data[Period] = LastMAXDate

)

var prvsyear =

CALCULATE (

SUM ( Data[Revised closing value] ),

Data[Period] = LastMAXDate-365

)

return DIVIDE((currentvalue-prvsyear),prvsyear)

any idea .thanks in advance 

[Anonymous]

@amitchandak   i have data set like mid date and end like 

    period                       Revised closing value

 01-4-2019                        45

 15-4-2019                        55

  .

  .

   .

 15-8-2020                        45

 01-9-2020                        55

 15-9-2019                        45

i want divide the current  year value ,previous year value. i am tring to apply measure getting value blank. how to get only month and year . my measure picking date also . i want only month year .  

 15-4-2019                        55

 01-4-2019                        45

 15-4-2019                        55

[Greg_Deckler]

@Anonymous You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

[amitchandak]

@Anonymous , Not very clear,

With help from date table you can have measures like

This year = SUM ( Data[Revised closing value] )

last year = CALCULATE(SUM ( Data[Revised closing value] ),dateadd('Date'[Date],-1,Year))

diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])

In date table, you can have month year etc to group data.