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 (         TRU...
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"
    )
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"
      • MBWATSON's avatar
        MBWATSON
        Icon for Helper II rankHelper II
        3 years ago

        Unfortunately it is still throwing the same error.