Calculated column to add new value

[NingMel]

I got a column in a table showing 'Work Order Type' (text column).  I need to add a new column to show a different value. 

For example if Work Order Type is 1, value in the new calculated column should show "1 - Reactive WO"

For example if Work Order Type is 2, value in the new calculated column should show "2 - Proactive WO", else shows "".

I thought I could use Switch , but it seems that Switch does not support comparing values of type Text.  What command should I use?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your DAX formula in the SWITCH function looks like, but please check and try the below.

Instead of writing 1 or 2, please try writing "1" or "2".

Because the column is TEXT data type, 1 and 2 in the column are also TEXT. So, I think, writing in a way of "1" or "2" (inside double quotation mark) might work for your case.

Thanks.

[NingMel]

Hi @Jihwan_Kim ,

Thank you.  I figured that out as well 🙂 I did delete this message but it's not gone.  Well I think I leave it here anyway, it may help others some way.  Thanks again.