Forum Discussion
jeeviscarozza
3 years agoRegular Visitor
Running Total by Lot Number
Hi! I am trying to get a running total of our items we have in stock for each item, by adding up the quantity of each consecutive lot. Each item has multiple lots. The product lot number column indi...
parry2k
3 years agoSuper User
jeeviscarozza could you please post the sample data with the expected output.
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
jeeviscarozza
3 years agoRegular Visitor
I am trying to get the running total of the quantity. For example, for this item it should be 10, then 20, then 30, etc. As a bonus, I want this calculation to stop when it reaches the quantitiy needed, which is 240.
- Ashish_Mathur3 years agoSuper User
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result.