Forum Discussion
Difference between two amounts (Measures or columns)
Hi All,
I am building a dashboard off sales data with sales values, back order amount values, open order amount values etc.
I have a trend graph showing back order amount values and open order amount by month.
I am looking for a dax function to calculate the difference between the 2 measures (back order amount and open order amount). Please note that the x axis is a drill down so it can be drilled down by quater, week etc. I will prefer for this dax function to take the drill down values into consideration.
Please see image of graph below
3 Replies
That worked Sir. What if i wanted to create the percent difference of between the two?
Percent Variance =
Var _Variance =[Back Order Amount]-[Open Order Amount]
return
_Variance/[Back Order Amount] //or _Variance/[Open Order Amount]Change the format to percentage.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
