Forum Discussion

MBWATSON's avatar
MBWATSON
Icon for Helper II rankHelper II
3 years ago
Solved

Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Con

Hello! I am fairly new to Power BI and I have seen questions similar to mine but the answers aren't working to solve my issue. I have the following SWITCH statement

ROLE = SWITCH (
        TRUE (),
            '_VIB Report 2022 08 07'[STATUS CHANGED BY] = "DYER, HEIDI S" && '_VIB Report 2022 08 07'[DEPARTMENT] = "WILSONVILLE", "PCP", "VIB" ,
            '_VIB Report 2022 08 07'[STATUS CHANGED BY] = "MINGS, JENNIFER" && '_VIB Report 2022 08 07'[DEPARTMENT] = "TANASBOURNE", "PCP", "VIB",
            '_VIB Report 2022 08 07'[STATUS CHANGED BY] = "HOJNACKI, LAUREN A" && '_VIB Report 2022 08 07'[DEPARTMENT] = "GLISAN", "PCP", "VIB")  
 
It is returning this error messge
Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
 
The previous posts have shown text statements. Any help appreciated!
 
Need Help
  • MBWATSON's avatar
    MBWATSON
    3 years ago

    Unfortunately it is still throwing the same error.

  • tamerj1's avatar
    tamerj1
    3 years ago

    MBWATSON 
    Ok must be my mistake. Please try

    ROLE =
VAR ChangedBy = '_VIB Report 2022 08 07'[STATUS CHANGED BY]
VAR Department = '_VIB Report 2022 08 07'[DEPARTMENT]
RETURN
    SWITCH (
        TRUE (),
        ChangedBy = "DYER, HEIDI S"
            && Department = "WILSONVILLE", "PCP",
        ChangedBy = "MINGS, JENNIFER"
            && Department = "TANASBOURNE", "PCP",
        ChangedBy = "HOJNACKI, LAUREN A"
            && Department = "GLISAN", "PCP",
        "VIB"
    )

5 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi MBWATSON 
    Please try

    ROLE =
SWITCH (
    VAR ChangedBy = '_VIB Report 2022 08 07'[STATUS CHANGED BY]
    VAR Department = '_VIB Report 2022 08 07'[DEPARTMENT]
    RETURN
        TRUE (),
    ChangedBy = "DYER, HEIDI S"
        && Department = "WILSONVILLE", "PCP",
    ChangedBy = "MINGS, JENNIFER"
        && Department = "TANASBOURNE", "PCP",
    ChangedBy = "HOJNACKI, LAUREN A"
        && Department = "GLISAN", "PCP",
    "VIB"
)
    • MBWATSON's avatar
      MBWATSON
      Icon for Helper II rankHelper II
      3 years ago

      Now I am getting this error message

      Failed to resolve name 'ChangedBy'. It is not a valid table, variable, or function name.

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        3 years ago

        MBWATSON 
        Strange that this is a key word. However, try

        ROLE =
SWITCH (
    VAR _ChangedBy = '_VIB Report 2022 08 07'[STATUS CHANGED BY]
    VAR _Department = '_VIB Report 2022 08 07'[DEPARTMENT]
    RETURN
        TRUE (),
    _ChangedBy = "DYER, HEIDI S"
        && _Department = "WILSONVILLE", "PCP",
    _ChangedBy = "MINGS, JENNIFER"
        && _Department = "TANASBOURNE", "PCP",
    _ChangedBy = "HOJNACKI, LAUREN A"
        && _Department = "GLISAN", "PCP",
    "VIB"