Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

DAX Formula: Inventory QOH in reverse

Disclaimer: I just started working with DAX and I've read and watched a ton of content but I'm still getting hung up on very simple problems.  I learn faster if I can see the solutions to the problem...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks, I learned a lot from that formula.  I assume it was meant to be a measure but I tried both and the result is always 12,955,306 for every date and every item.  It appears it might be adding up all QOH in my Inventory Data table?

 

Also, the only field I have qty in is the 'Transaction Data' [Qty]. there is another field: 'Transaction Data' [Transaction Type] which captures "adjustment", "Receipt", etc...  I changed the 3 lines on your formula to : SUM ( 'Transaction Data'[Qty] ),

 

 

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Could you share a sample pbix file, so that we can better assist on this issue? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

 

Regards