Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SWITCH function with result TEXT

Hello all,   I have something pretty simple i guess, but i can not figure this out how with DAX. I am looking for a result "Yes"or "No" as text.   On Time Correction Result Yes Yes Yes...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

Looks ok from here so you'll have to debug at your side.  Presumably it's the 3rd clause causing problems.  You can comment it out to test.

Have you definitely got && as the logical 'and'?  Maybe you could test with e.g. 

Result2 = switch(true,
Tbl[On Time]="Yes", "Yes",
Tbl[On Time]="", "",
AND(Tbl[On Time]="No", 1), "Yes")  to see if you can get past the error
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello HotChilli,

 

Thanks,

 

But unfortunately, i can not solve it.

I tried it with your proposal.

Result = Switch(TRUE(,

Tbl[On Time]="Ja","Ja",

Tbl[On Time]="","",

AND(Tbl[On Time ]="Ja",Tbl[Correction]="Ja"),"")

 

Error:

DAX comparison operations do 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.

 

If i am leaving the last part of the formula from the "AND" function away, it works find.

But of couse misses the last part.

So is has something to do something with this combined conditions.

 

Do you have other options?

 

Gr