DAX Hourly Variance Percentage Formula

[RickyBurton]

Hello,

I am playing about in Power BI and have become stuck I am trying to work out the variance in percentage between to numbers,

This is the formula i have found that works but need to right it as a measure or column which would be best.

To calculate the percentage increase:

First: work out the difference (increase) between the two numbers you are comparing.

Increase = New Number - Original Number

Then:  divide the increase by the original number and multiply the answer by 100.

% increase = Increase ÷ Original Number × 100.

If your answer is a negative number then this is a percentage decrease.

To calculate percentage decrease:

First: work out the difference (decrease) between the two numbers you are comparing.

Decrease = Original Number - New Number

Then: divide the decrease by the original number and multiply the answer by 100.

% Decrease = Decrease ÷ Original Number × 100

If your answer is a negative number then this is a percentage increase.

If you wish to calculate the percentage increase or decrease of several numbers then we recommend using the first formula. Positive values indicate a percentage increase whereas negative values indicate percentage decrease.

how can this be done?

[v-caliao-msft]

@RickyBurton,

For your issue, you could use a IF function to check which one is larger, New Number or Original Number. The sample expression would like below.
Difference=IF(New Number >Original Number,New Number - Original Number,Original Number - New Number)

If this is not what you want, please provide us some sample data, and elaborate your requirement, so that we can make further analysis.

Regards,

Charlie Liao

[RickyBurton]

@v-caliao-msftThanks for the reply, what I am after is getting the percentage variance.

of Hours input against Hours Against = my varience%