Forum Discussion

joe231's avatar
joe231
Frequent Visitor
4 years ago
Solved

HELP with Negative Return Values

Hi All -   in a measure column, I am Trying to calculate %difference between 2 columns (Result 1 column) that results into Negative values. I want the negative values to positive and keep the posit...
  • Adescrit's avatar
    Adescrit
    4 years ago

    Hi joe231 ,

     

    How about this:

    % Difference = 
VAR __Measure_Value = Data[Result2] 
VAR __Baseline_Value = Data[Result1]
VAR __Calculation = DIVIDE( __Measure_Value - __Baseline_Value , __Baseline_Value )
RETURN
    IF( __Calculation < 0, __Calculation * -1, __Calculation )
v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi joe231 ,

 

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

 

Best regards,

Yadong Fang