Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
3 years ago
Solved

Error in Switch Function

Hi All,   Could someone help e in resolving the below DAX? I am encountering this "Function "SWITCH' does not support comparing values of type True/False with values of type Text. Consider using t...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi  RanjanThammaiah

     

    you shall replace TRUE() with the intended comparing column, like:

    Column = SWITCH(
        TableName[ColName],
        CONCATENATEX(
            'Keyword Search',
            IF(
                SEARCH('Keyword Search'[Keyword Search],'Opps & Engage'[EngagementName],,999) <> 999,
                'Opps & Engage'[EngagementName]&" ",
                ""
                )
            ),
            CONCATENATEX(
                'Exception-Cons',
                    IF(
                        SEARCH('Exception-Cons'[ID],'Opps & Engage'[SourceofOpportunity],,999) <> 999,
                        'Exception-Cons'[Exception]&" ",
                        ""
                    )
            ),
            "Other"
    )

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi  RanjanThammaiah

 

you shall replace TRUE() with the intended comparing column, like:

Column = SWITCH(
    TableName[ColName],
    CONCATENATEX(
        'Keyword Search',
        IF(
            SEARCH('Keyword Search'[Keyword Search],'Opps & Engage'[EngagementName],,999) <> 999,
            'Opps & Engage'[EngagementName]&" ",
            ""
            )
        ),
        CONCATENATEX(
            'Exception-Cons',
                IF(
                    SEARCH('Exception-Cons'[ID],'Opps & Engage'[SourceofOpportunity],,999) <> 999,
                    'Exception-Cons'[Exception]&" ",
                    ""
                )
        ),
        "Other"
)