A circular dependency was detected

[chinaik123]

Hi , I require help for Circular Dependency.

Basically i wish to count my orders that is due for the next 2 weeks (e.g from 31/5 to 16/6) and 1 month (31/5 to 30/6)
I have come up with the calculated column for 2 weeks. However, when i am using the same column for the 1 month, it showed me that a circular dependency has occured.

Order (Two weeks)=

CALCULATE

(SUM('Sheet1'[Qty R]),

FILTER(ALLNOBLANKROW('Sheet1'[Date]),

Sheet1[Date]>=WEEKNUM(TODAY(),1) && Sheet1[Ex In Date week]<=WEEKNUM(TODAY(),1)+2))

I changed the +2 at the end to a +4 to calculate monthly but the error then occurs.

Could anyone help in this?

[chinaik123]

Hi @aggiebrown , is the link to the sample data OK? 

[aggiebrown]

Hi @chinaik123,

Can you please share your sample data?

[chinaik123]

Hi @aggiebrown  Please find the excel file provided 
https://www.dropbox.com/scl/fi/zdaaiqzaoginoxb4a7hk2/sample-data.xlsx?dl=0&rlkey=dj9mk84skew4ixsvjpr...

The sample output is that if the Incoming date falls under today date plus 2 weeks then the quantity should be taken. 

In power BI, i am using the formula as shown on top.

Thanks,

Ricky