IF AND DAX Error

[Anonymous]

Hi Experts

Getting and error with my IF (AND( dax measure and cannot see what i have done wrong?

Oder Type (new) = IF(AND(NEWBI_COMPS[Order Type]="Maintenance",NEWBI_COMPS[Renewal]="True"),"Renewal",IF(AND(NEWBI_COMPS[Order Type]="Maintenance",NEWBI_COMPS[Renewal]="False"),"New",NEWBI_COMPS[Order Type]))

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Try this:-

Oder Type (new) =
SWITCH (
    TRUE (),
    AND ( NEWBI_COMPS[Order Type] = "Maintenance", NEWBI_COMPS[Renewal] = "True" ), "Renewal",
    AND ( NEWBI_COMPS[Order Type] = "Maintenance", NEWBI_COMPS[Renewal] = "False" ), "New",
    NEWBI_COMPS[Order Type]
)

Thanks,

Samarth