Using if statement with multiple name changes

[Anonymous]

Hi

I have a table with short names like "ASIF" "FASC" etc.
I need to rename all of them like "ASIF" to "Artificial" and "FASC" to "Fashion" etc.
I know I can do that easly in query editor but then I will break my data folding, I need to do this with a measure or new column without using query editor ( inside the left "Data" button ).

I have googled it but none answer what I really need.

[amitchandak · Accepted solution]

@Anonymous , Power Query, or new column DAX are two options

example

In DAX

Switch( [Col1]

"ASIF" , "Artificial" ,

"FASC" , "Fashion",

"Other"

)

[Anonymous]

Works perfectly, thank you.