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"),"Renewal",IF(AND(NEWBI_COMPS[Order Type]="Maintenance",NEWBI_COMPS[Renewal]="False"),"New",NEWBI_COMPS[Order Type]))
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

1 Reply

  • 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