Forum Discussion
Solved
Dax column - Available Quantity Calculation not working
Hello - I have a relatively simple power bi report that works with Inventory data. The columns in my model are Item Code Item Code Desc Order Type Total Quantity on hand (Constant value p...
Hi EricPad ,
Thanks for the reply from Ashish_Mathur , please allow me to provide another insight:
You can create a measure.
Available = MAX(vw_OpenOrdersByItem[TotalQuantityOnHand]) - SUM(vw_OpenOrdersByItem[NetOnOrder])If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This worked perfectly! Thank you so much!
I tried something similar as a column but not a measure. Thank you again for your help!
Hi,
Share the download link of the PBI file. Clearly show the problem there.
where can I share it to?
Upload it to Google Drive and share the download link.