Forum Discussion
Inventory Running Total
Hi all! I am trying to set up my data to make this do what I want it to, but it keeps not doing that!! I have this pbix file: https://drive.google.com/file/d/16bRDCCQ1z9UQby2SRNZ-misKplOwuYS...
From where this initial inventory of 39 will come. Is it 39 for all products?
Hi amitchandak I am so sorry I should have explained that wayyy better. I was switching back and forth between my actual file and the simplified version I posted to this thread and so I didnt think to explain it.
So not included in the file data but from what we know initially:
Product A starting inventory level = 28
Product B = 10
Product C = 1
Every time(date occurance) the Inventory Impact is + we want to add that to the initial inventory level, and every time it is - we want to subtract from that.
