Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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