Forum Discussion

Sagimore88's avatar
Sagimore88
Frequent Visitor
4 years ago
Solved

New Switch Column

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 VAL...
General Comment
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    Sagimore88 , There was an syntax issue

     

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

Sagimore88's avatar
Sagimore88
Frequent Visitor
4 years ago

Thank you 🙂