Forum Discussion

kjani's avatar
kjani
Icon for Helper I rankHelper I
6 years ago
Solved

Help in building a template

I would like your help in building this in PowerBI Desktop. I have a dataset with multiple variables. I need to calculate difference in values based on scenario (e.g. 1_Base vs. 2_Low) for each Name ...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi kjani ,

     

    Check the code for the measure. It is subtracting the values and get the absolute value.

     

    Ricardo

kjani's avatar
kjani
Icon for Helper I rankHelper I
6 years ago

Thank you so much for quick response. However, I need the difference between the two scenarios. Your output is adding instead of subtracting. Thanks again.

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi kjani ,

 

Check the file again, I've updated it.

 

Ricardo

  • kjani's avatar
    kjani
    Icon for Helper I rankHelper I
    6 years ago

    I am sorry, it's still adding the numbers. I need to see the difference in values between two scenarios (1_Base vs. 2_Low). Can you help? Thanks

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi kjani ,

       

      Check the code for the measure. It is subtracting the values and get the absolute value.

       

      Ricardo