Forum Discussion

EricPad's avatar
EricPad
Regular Visitor
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

  • EricPad's avatar
    EricPad
    2 years ago

    This worked perfectly! Thank you so much! 

    I tried something similar as a column but not a measure. Thank you again for your help!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • EricPad's avatar
    EricPad
    Regular Visitor
    2 years ago

    This worked perfectly! Thank you so much! 

    I tried something similar as a column but not a measure. Thank you again for your help!