Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

IF AND DAX Error

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"),"Ren...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

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