Dynamic Percentage Change based on the slicer selection Year

[chotu27]

Hi All,

@v-alq-msft 

I need calculation for below percentage change. When i  select multiple years from slicer it should compare and display percentage changed for latest year.

Group	Sales	year	percentage Diff
NAP	50	2019
NAP	25	2020	-50%
BTP	100	2019
BTP	75	2020	-25%
ACT	100	2019
ACT	60	2020	-40%

[amitchandak · Accepted solution]

Try like

this year =
var _thisyear = maxx(table,table[year])
return
calculate(sum(table[sales]),all(table[year]),table[year]=_thisyear)


last year =
var _thisyear = maxx(table,table[year])-1
return
calculate(sum(table[sales]),all(table[year]),table[year]=_thisyear)