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 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?

Need Help
  • smpa01's avatar
    smpa01
    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. 

2 Replies

  • smpa01's avatar
    smpa01
    Community Champion
    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. 

    • ngomes's avatar
      ngomes
      Helper II
      4 years ago

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