Forum Discussion

ngomes's avatar
ngomes
Helper II
4 years ago
Solved

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's avatar
    4 years ago

    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.