How to get the percentage increase/decrease from start of time to now?

[derekli1700]

As seen in above matrix table - im curious on how to make the final total percentages in the most bottom row show the amount increase/decrease from 2020? For eg) Card's bottom row should show 9.7% rather than 42.345. I have attached a sample dashboard with dummy data for reference:
Sample.pbix

@Anonymous 

[amitchandak · Accepted solution]

@derekli1700 , Create meausure like , Use New % in place of % measure

//Only year vs Year, not a level below

Min Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=Minx(allselected('Date'),'Date'[Year])))
Max Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=Maxx(allselected('Date'),'Date'[Year])))
New % = if(isinscope('Date'[Year]), [%], divide([Max Year]-[Min Year ],[Min Year ]))

Assumes you have separate date or year table