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?

 

[Matt Allington]

It’s because you are using a column, not a measure. Columns are calculated by row, not across the total.
write a measure.

divide(sum(column22) -sum(column21),sum(column))