Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How can I fix this error in DAX code?

The below is a column created with DAX, which checks whether the value in the "Value" column is more than the "Min" column and less than the "Max" column, and will will display "In Limits" if this is...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Anonymous , Try this one:-

    CL OOL =
SWITCH (
    TRUE (),
    AND (
        IFERROR ( INT ( Panel[Value] ), "Not Running" ) >= Panel[Min],
        IFERROR ( INT ( Panel[Value] ), "Not Running" ) <= Panel[Max]
    )
        || Panel[Index] IN { 91, 92, 93, 94 }, "In Limits",
    IFERROR ( INT ( Panel[Value] ), "Not Running" ) = "Not Running", "Not Running",
    "OOL"
)
Tahreem24's avatar
Tahreem24
Super User
4 years ago

Anonymous ,Try this code:

 = SWITCH(TRUE(),
Value>=Min && Value<=Max,"In Limits",
Panel[Index] = 91 || Panel[Index] = 92 || Panel [Index] = 93 || Panel[Index] = 94,"In Limits",
Value="NA","Not Running","OOL")

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Tahreem24 , it gave the error "The syntax for '&&' is incorrect". Here is a picture of my data if it helps. Ignore columns with cross.