Help with switch case

[Rup10]

Hi,

I have to add one custom column called "different" by using switch case as below : 

CASE

WHEN (diff <= 5) and (diff >= -5) THEN 'direct offset'

WHEN diff < -5 THEN 'overpay offset'

END

I tried below switch case but it is showing error as "DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values".

Switch case : 

different = SWITCH( TRUE(),

AND([diff] <= -5 , [diff] >= -5 ), "directoffset",
[diff] < -5 ,"overpayoffset"
)

Can someone please help me with this.

Thank you.

[speedramps]

Please consider this solution and leave kudos

Look at the message "DAX comparison operations do not support comparing values of type Text with values of type Integer."

This suggests that [diff] is text.   

If [diff] is a column in your query then change the data type from text to numeric>

If [diff] is a measure then you can covert it to a number

diff_number =

var diff_text = "-5"

RETURN

CONVERT(text1, INTEGER)

[dedelman_clng · Accepted solution]

Hi @Rup10  - the most likely culprit is that [diff] is formatted as text. Change it to some number format either in Transform Data or in the model itself and it ought to work.

(Side note, and this is probably just an error in typing the post, but your first option on switch has "-5" on both inequalities)

Hope this helps

David

[Rup10]

Hi @dedelman_clng ,

Thank you so much.It helped me alot.