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"
)
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Anonymous ,

 

Pls try this:-

CL OOL =
SWITCH (
    TRUE (),
    AND ( INT ( Panel[Value] ) >= Panel[Min], INT ( Panel[Value] ) <= Panel[Max] )
        || Panel[Index] IN { 91, 92, 93, 94 }, "In Limits",
    Panel[Value] = "NA", "Not Running",
    "OOL"
)

 

Thanks,

Samarth

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Samarth_18 ,

     

    Your code gave this error: "Cannot convert value 'NA' of type Text to type Number". My Value column has type text because it holds both numbers and "NA" values. 

    • Samarth_18's avatar
      Samarth_18
      Community Champion
      4 years ago

      Anonymous ,Pls try now:-

      CL OOL =
VAR result =
    IF (
        AND ( INT ( Panel[Value] ) >= Panel[Min], INT ( Panel[Value] ) <= Panel[Max] )
            || Panel[Index] IN { 91, 92, 93, 94 },
        "In Limits",
        "OOL"
    )
RETURN
    IFERROR ( result, "Not Running" )
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks Samarth_18 ,

         

        It still seems to return the same error though. Here is a picture of some of my data if it helps.