Error in Switch Function

Question

Hi All,&nbsp;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.&nbsp;Column = SWITCH(&nbsp; &nbsp; TRUE(),&nbsp; &nbsp; CONCATENATEX(&nbsp; &nbsp; 'Keyword Search',&nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; SEARCH('Keyword Search'[Keyword Search],'Opps &amp; Engage'[EngagementName],,999) &lt;&gt; 999,&nbsp; &nbsp; &nbsp; &nbsp; 'Opps &amp; Engage'[EngagementName]&amp;" ",&nbsp; &nbsp; &nbsp; &nbsp; ""&nbsp; &nbsp; &nbsp; &nbsp; )),&nbsp; &nbsp; &nbsp; &nbsp; CONCATENATEX(&nbsp; &nbsp; 'Exception-Cons',&nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; SEARCH('Exception-Cons'[ID],'Opps &amp; Engage'[SourceofOpportunity],,999) &lt;&gt; 999,&nbsp; &nbsp; &nbsp; &nbsp; 'Exception-Cons'[Exception]&amp;" ",&nbsp; &nbsp; &nbsp; &nbsp; ""&nbsp; &nbsp; &nbsp; &nbsp; )),"Other"&nbsp;&nbsp;

freemanz · Accepted Answer

hi &nbsp;RanjanThammaiah&nbsp;you shall replace TRUE() with the intended comparing column, like:Column = SWITCH(&nbsp;&nbsp;&nbsp;&nbsp;TableName[ColName],&nbsp;&nbsp;&nbsp;&nbsp;CONCATENATEX(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;'Keyword Search',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;IF(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;SEARCH('Keyword Search'[Keyword Search],'Opps &amp; Engage'[EngagementName],,999) &lt;&gt; 999,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;'Opps &amp; Engage'[EngagementName]&amp;" ",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;""&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;)&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CONCATENATEX(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;'Exception-Cons',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;IF(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;SEARCH('Exception-Cons'[ID],'Opps &amp; Engage'[SourceofOpportunity],,999) &lt;&gt; 999,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;'Exception-Cons'[Exception]&amp;" ",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;""&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;)&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;),&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"Other")&nbsp;

Forum Discussion

Error in Switch Function

1 Reply

Related content

Switch functions error

Switch Logic Error

AI functions with PySpark error

Switch or If Function

Error in Switch Function