Forum Discussion
DAX Hourly Variance Percentage Formula
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 righ...
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
v-caliao-msftThanks for the reply, what I am after is getting the percentage variance.
of Hours input against Hours Against = my varience%