Create opening and closing stock in the data columns (trouble with circular dependecy)

[William_Moreno]

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.

[PhilipTreacy · Accepted solution]

Hi @William_Moreno 

Download sample PBIX fle

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

[William_Moreno]

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.