Finding the percentage difference against previous period taking into account years

[Anonymous]

Hi Experts

See sample PBIX, If you scroll down to Dec 2020 I am not able to compare the Percenatge Difference against Jan 21 - But i can compare the in Year Month Differences ie.

Jan 2021 v Feb 2021

how do i amend the current measure to allow me to compare month on month % difference whlist taking into account the year too.

Sample

https://www.dropbox.com/s/ymuu7z7gnhnzd3f/Mtnovermtn.pbix?dl=0 

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

total sales same week# previous month = 
var _max = Max(Dates[Date])
var _date = date(year(_max), month(_max)-1, Day(_max))
VAR currentyear = Year(_date)
VAR currentmonth = Month(_date)
VAR currentweeknumber = MAX(Dates[Week of Month])
RETURN
CALCULATE([total sales], FILTER( ALL(Dates), Dates[Year] = currentyear && Dates[MonthNo] = currentmonth  && Dates[Week of Month] = currentweeknumber))

[Anonymous]

Hi Amit - getting error on this line 

var _date = date(year(_max), month(_max)-1, Day(_max))