If condition in Set Analysis

[joeychua]

I intend to create a table to display a 'Message' in an IF condition. The IF condition is between 9-12 months of data and a specific Status, while the other IF condition is 3-6 months of data

This is my expression,

=Maxstring(

if(

{<[Proposal Approval Date]={">=$(=Date(AddMonths(LasRefresh,-12))) <=$(=Date(AddMonths(LasRefresh,-9)))"}

,[Status]= 'In Progress')

if

{<[Proposal Approval Date]={">=$(=Date(AddMonths(LasRefresh,-6)))""<=$(=Date(AddMonths(LasRefresh,-3)))"}

,[Status] = 'Completed'))

>}'Expired')

[Arthur_Fong]

What is the issue you facing?