HELP with Negative Return Values

[joe231]

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 positive values as positive. 

I simply could  mulitply the column to -100 but it also affects positive values and turns them into negative.

I was hoping  an "if" modification in this formula

[v-yadongf-msft]

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

[Adescrit · Accepted solution]

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 )