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.
Hello
I'm tring to create a calculated column of Sales QTY divided by Booked in QTY to give me a Stock Movement percentage.
I have tried this;
Stock Movement = Append1[SQTY] / Append1[book_qty]
But it come up with Infinity.
I have a screen shot;
What is the DAX to get the correct calculation?
Regards
GrahamR99
Solved! Go to Solution.
Hi @GrahamR99,
Please use this formula ( use calculate rather than the column) and let us know if it does not work:
Stock Movement = Divide(Calculate(Append1[SQTY]),calculate(Append1[book_qty]),0)
Thx
Ninter
Hello Ninter
Your formula did not work sorry;
I had to change it to;
Divide(Calculate(Sum(Append1[SQTY])),calculate(Sum(Append1[book_qty])),0)
Thank you for your help.
Regards
GrahamR99
Hi @GrahamR99,
Please use this formula ( use calculate rather than the column) and let us know if it does not work:
Stock Movement = Divide(Calculate(Append1[SQTY]),calculate(Append1[book_qty]),0)
Thx
Ninter
Hello Ninter
Your formula did not work sorry;
I had to change it to;
Divide(Calculate(Sum(Append1[SQTY])),calculate(Sum(Append1[book_qty])),0)
Thank you for your help.
Regards
GrahamR99
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |