Forum Discussion

NingMel's avatar
NingMel
Frequent Visitor
4 years ago
Solved

Calculated column to add new value

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's avatar
    Jihwan_Kim
    4 years ago

    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.

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      NingMel
      Frequent Visitor
      4 years ago

      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.