Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Formart Column from number to text

Hi 

 

I have a column within a table ('Service'.[Consent]) with values of 1, 2, 3 and I want to format the column so the numbers represent:

1 = Yes

2 = No

3 = Not Required

 

PLease help

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Create a column

    Column = SWITCH([Consent],1,"Yes",2,"No",3,"Not Required")

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    Create a column

    Column = SWITCH([Consent],1,"Yes",2,"No",3,"Not Required")

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.