New Switch Column

Question

Hello,Getting the following error and cant find a fix in similiar questions.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.&nbsp;I'm attempeting to create a new column using Switch.&nbsp;PastDue = SWITCH('Table1'[Column1]=0,"exclude",1,"exclude") - I need to continue this through 30 months.&nbsp;Column1 is a calc column format&nbsp;Overdue Period = DATEDIFF('Tablex'[Received_DT], TODAY(),MONTH)&nbsp;Column1 format is whole number. The new Column format to Text.&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

Sagimore88 , There was an syntax issue 
&nbsp;
PastDue = SWITCH('Table1'[Column1],0,"exclude",1,"exclude")

Forum Discussion

New Switch Column

2 Replies

Related content

Alternative to SWITCH ()?

Switch -Containsstring

Using Switch

Order switching mid workflow

Switch Time Zone on DateTime Columns based on User Selection