Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys, again I need help!
My problem today is about circular dependecy.
I tried to build a data table for opening e closing stock, but I've had faced problems to finish it.
I need to do it with columns data, at this point I didn't want to use measures. Is it possible?
Table
Local | Code | UM | Data | OpeningStock | Sales | Order | Necessity | ClosingStock | Goal |
Italy | PACKGING | UN | 01/03/2021 | 230.200 | 791.907 | 504.000 | 891.601 | 833.895 | 833.895 |
Italy | PACKGING | UN | 01/04/2021 | 833.895 | 860.442 | 756.000 | 104.442 | 833.895 | 833.895 |
Italy | PACKGING | UN | 01/05/2021 | 833.895 | 926.248 | 1.008.000 | 0 | 915.646 | 833.895 |
Italy | PACKGING | UN | 01/06/2021 | 915.646 | 988.920 | 0 | 907.168 | 833.895 | 833.895 |
The column Necessity has this formula:
IF(Goal - (OpenningStock + Order - Sales)<0;0;Goal - (OpenningStock + Order - Sales))
The column ClosingStock has this formula:
OpeningStock + Order + Necessity - Sales
Someone could help me?
Thanks a lot.
William M.
Solved! Go to Solution.
I'm not getting a circular dependency error with those column calculations. You are? If so please show screenshots and more details.
Here are my columns
Necessity = IF([Goal] - ([OpeningStock] + [Order] - [Sales])<0, 0 , [Goal] - ([OpeningStock] + [Order] - [Sales]))
ClosingStock = [OpeningStock] + [Order] + [Necessity] - [Sales]
Regards
Phil
Proud to be a Super User!
I'm not getting a circular dependency error with those column calculations. You are? If so please show screenshots and more details.
Here are my columns
Necessity = IF([Goal] - ([OpeningStock] + [Order] - [Sales])<0, 0 , [Goal] - ([OpeningStock] + [Order] - [Sales]))
ClosingStock = [OpeningStock] + [Order] + [Necessity] - [Sales]
Regards
Phil
Proud to be a Super User!
Hi Phillip, thanks for answer me. I've forgot to say that the column OpeningStock has to be calculated by this logical formula is the CloseStock of the last month. Thanks again.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |