A circular dependency was detected

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?