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

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.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    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"
    )