Forum Discussion
Solved
Yearly Change Percentage on Matrix
Hi, I'm trying to add '% Change from Last Year' column onto this matrix. Is it possible to add in a column that looks at one year (e.g. 2022) then works out the percentage difference to the year prio...
Thanks for your help. When I try the following syntax, when I get to VAR_Diff, it only recognises VAR_This Year and not Last Year. Do you have any idea what may be going wrong with the second line? Attached is a photo of the error bar (my table/data is called Domicile in the error that I have changed below for ease).
Yearly Change =
VAR __ThisYear = SUM(Table[Applications.])
VAR __LastYear = SUMX(FILTER('Table',[Year] = MAX('Table'[Year] -1, [Applications.]