New Switch Column

[Sagimore88]

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.

I'm attempeting to create a new column using Switch.

PastDue = SWITCH('Table1'[Column1]=0,"exclude",1,"exclude") - I need to continue this through 30 months.

Column1 is a calc column format 

Overdue Period = DATEDIFF('Tablex'[Received_DT], TODAY(),MONTH)

Column1 format is whole number. The new Column format to Text.

[Sagimore88]

Thank you 🙂

[amitchandak · Accepted solution]

@Sagimore88 , There was an syntax issue

PastDue = SWITCH('Table1'[Column1],
0,"exclude"
,1,"exclude")