Formart Column from number to text

[Anonymous]

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

[v-juanli-msft · Accepted solution]

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.