Help - DAX formula

[ngomes]

Hello everyone,

I would like to ask you for help with a problem I have with a calculated column 22VS21.
what I wanted was that the column 22vs21 = (2022 values - 2021 values) / 2021 values

the calculations should result to client 1
22vs21 = (300 - 200) / 200 = 0,5

the table with the results

I can't understand what I'm doing wrong in the formula, can someone help me?

[smpa01 · Accepted solution]

@ngomes  instead of using calculated column, you need to use measures 

MEASURE = DIVIDE((SUM(tbl[2022])-SUM(tbl[2021]))/SUM(tbl[2021]))

 Unless you use measures, the values from calculated table will not be aggregated the way you are desiring. 

[ngomes]

that's right, thanks so much for the help.