How to detach in Set analysis

[bhaveshp90]

Hello, 

I have an expression below to calculate the delay days as shown below; (I want to permanently lock this table so I have used {1} in my expression.)

 = if(Sum(Final_Acceptance)>3500, null(),

(Sum({1<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),0), 'YYYY-MM-DD'))"}>}Final_Acceptance)
/
(count({1<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-1), 'YYYY-MM-DD'))"}>}distinct Milestone_Project_Number))))

This expression is working irrespective of year selected, but when I unselect month the table is changing. 

Any idea how to fix this? 

PS: Year(Date) as Year and Month(Date) as Month 

thanks

Bhavesh

[sunny_talwar]

Just combined the set analysis from your other two expressions (set analysis on sanpshot_date) and added it to the if clause expression.

[bhaveshp90]

Awesome  thank you sir