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
rrm121812's avatar
rrm121812
Icon for Helper II rankHelper II
3 years ago

Hi Shabir,

 

You can try this DAX : On Hands Quantity =VALUES('PowerBIInventonhanditem'[AvailPhysical]).

 

If this is what you were looking for, please provide a Kudo and Accept this as a solution for better reach to other people.

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

    Hi rrm121812 

     

    I did   

    OnHnad = VALUES(POWERBIUEINVENTONHANDITEM[AVAILPHYSICAL]).
    But Error , DIdn't work for me
     
    Best Regards,
    Shabir Ahmad
    • rrm121812's avatar
      rrm121812
      Icon for Helper II rankHelper II
      3 years ago

      Can you share pbix file? 

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

        How can i share here is not option of file attached.

         

        Best Regards,

        Shabir Ahmad