Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Nanakwame
Try this:
Variance = [Back Order Amount]-[Open Order Amount]
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @Nanakwame
Try this:
Variance = [Back Order Amount]-[Open Order Amount]
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |