DAX - Switch, True Formula - What is wrong with my code?

[SimonWeber]

Hello again

I have an issue with the following Switch/True formular.

If I write only this:

it is working

If I write it like this:

it is not working!

There error message says: The Switch-Function doesn't support comparison between True/False and Text.

Has somebody any idea what I do wrong? I found in the net a lot of example and all of them looks like my code.

 

Kind Regards,

Simon

[MattAllington · Accepted solution]

My guess is you have cut and paste incorrect inverted commas. Look at them in the post above, some are smart quotes and some are not. 

[SimonWeber]

Now I see my error!

It should only be

 ..."30";"MDE-Laufzettel";"nicht HWZ

instead of

 ...."30"; "30";"MDE-Laufzettel";"nicht HWZ

Thanks a lot... Now it is working 🙂