Forum Discussion
PowerPivot Circular Reference Help
Hi,
To the best of my knowledge, this is circular logic even to a layperson (not an MS Excel user). Production depends up on the closing stock of the previuos month and closing stock of the previous month depends up on the production in that month. Even if you try to create formulas for this in an MS Excel file, how you will solve this. What will those formuals be?
Hello,
Implementing in excel is straightforward. The production and closing calculations for the first period is different from the remaining periods.
First Period Production Calculations
Second Period and onwards calculation
First period closing calculation
Second Period and onward closing calculations
Final overall desired output (production and closing and calculated data, rest are input data)
implementing this in excel is easy, but i am trying for a PBI solution as there are 100's of SKUs that I need to apply it to.
Thanks
OD