Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
In below table, I would like to calculate ClosingStk based on ShiftDate and SizeNo.
The first ClosingStk for the same SizeNo should be using InitialStkCount (column G) + CuredQty (column D) - StkInQty (column C).
Subsequent and remaining ClosingQty for the same SizeNo should be using ClosingStk from previous row (column F) + CuredQty (column D) - StkInQty (column C).
Please help.
ShiftDate | SizeNo | StkInQty | CuredQty | InitialStkCount | Closing Stk | |
1/1/2024 | A001 | 100 | 333 | 433 | ||
2/1/2024 | A001 | 864 | 964 | 433 | 533 | |
3/1/2024 | A001 | 160 | 263 | 533 | 636 | |
4/1/2024 | A001 | 636 | 636 | |||
5/1/2024 | A001 | 345 | 550 | 636 | 841 | |
2/1/2024 | B001 | 112 | 128 | 86 | 102 | |
3/1/2024 | B001 | 68 | 52 | 102 | 86 | |
4/1/2024 | B001 | 235 | 300 | 86 | 151 | |
5/1/2024 | B001 | 151 | 151 | |||
2/1/2024 | C001 | 280 | 336 | 268 | 324 | |
3/1/2024 | C001 | 112 | 126 | 324 | 338 | |
4/1/2024 | C001 | 135 | 250 | 338 | 453 | |
5/1/2024 | C001 | 325 | 400 | 453 | 528 |
Thank you.
Regards,
LC
Solved! Go to Solution.
for fun only, a showcase of powerful Excel formulas,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |