Forum Discussion

shabirAhmad's avatar
shabirAhmad
Icon for Helper II rankHelper II
3 years ago

On hand Value in DAX

Hi Experts,   I just need on hand Quantity on the below table as i am new to Power Bi can someone give me suitable DAX code to achieve this quatity.Thanks in Advance as you experts resolve my other...
Need Help
shabirAhmad's avatar
shabirAhmad
Icon for Helper II rankHelper II
3 years ago

Hi to all,

 

What is the issue, this field is coming from dynamics ERP so there is it was shown on the form a calculated column such as "Measure" in DAX. 

shabirAhmad's avatar
shabirAhmad
Icon for Helper II rankHelper II
3 years ago

Hi All,

This is the code in Dynamics ERP system to display the onhand quantity

 

return this.PostedQty + this.Received - this.Deducted + this.Registered - this.Picked;

 

In DAX i applied the below formula in Measure

 

On Hand = SUM(POWERBIUEINVENTONHANDITEM[POSTEDQTY]) + SUM(POWERBIUEINVENTONHANDITEM[RECEIVED]) - SUM(POWERBIUEINVENTONHANDITEM[DEDUCTED]) + SUM(POWERBIUEINVENTONHANDITEM[REGISTERED]) - SUM(POWERBIUEINVENTONHANDITEM[PICKED])- SUM(POWERBIUEINVENTONHANDITEM[RESERVPHYSICAL])

 

 

Best Regards,

Shabir Ahmad