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 sho...
  • 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.

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.