Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |