Forum Discussion
ngomes
4 years agoHelper II
Help - DAX formula
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...
smpa01
4 years agoCommunity Champion
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
4 years agoHelper II
that's right, thanks so much for the help.