Cirlular denpendency to calculate the opening and ending inventory

[yanzhao_LBS]

hello i want to create the opening and ending inventory like this 

but the system error :Cirlular denpendency was detected . I know there is a Cirlular denpendency,but is there any possible to  achieve my request?

[yanzhao_LBS]

@Ritaf1983 Thanks for your reply. I am trying to attach the file but found only Wetransfer is available for me but it seems need the receiver's email address to make the share file. if you can give me a email i can send the pbix file to you .

i am trying to make the data here

table1 inventory

name	Opening inventory	Date
A	100	2023-1-1
A	0	2023-2-1
A	0	2023-3-1
A	0	2023-4-1
A	0	2023-5-1
A	0	2023-6-1
A	0	2023-7-1
A	0	2023-8-1
A	0	2023-9-1
A	0	2023-10-1
A	0	2023-11-1
A	0	2023-12-1

table 2 sales

name	Sales	Date
A	10	2023-1-1
A	20	2023-2-1
A	3	2023-3-1
A	5	2023-4-1
A	10	2023-5-1
A	7	2023-6-1
A	8	2023-7-1
A	9	2023-8-1
A	1	2023-9-1
A	2	2023-10-1
A	3	2023-11-1
A	3	2023-12-1

Table 3-date

date	Year	month
2023-1-1	2023	01
2023-2-1	2023	02
2023-3-1	2023	03
2023-4-1	2023	04
2023-5-1	2023	05
2023-6-1	2023	06
2023-7-1	2023	07
2023-8-1	2023	08
2023-9-1	2023	09
2023-10-1	2023	10
2023-11-1	2023	11
2023-12-1	2023	12

and 

create Measure 

End Inventory =[Open Inventory]-SUM(sales[Sales])

Open Inventory = CALCULATE([End Inventory],DATEADD('date'[date],-1,MONTH))+SUM(Inventory[Opening inventory])

I know that End Inventory & Open Inventory are in the endless loop, but want i want is 

Open Inventory(current month)=End Inventory(last month)

End Inventory(current month)=Open Inventory(current month)-sales(current month)

just like this.

Thanks.

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[Ritaf1983]

Hi @yanzhao_LBS 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523