Error in Switch Function

[RanjanThammaiah]

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 the VALUE or FORMAT function to convert one of the values." error.

Column = SWITCH(

    TRUE(),

    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 · Accepted solution]

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"

)