Change Number to a Word

[Elijabrnc]

Hallo I want to change the 0 and 15 into word's. So that they are called normal and import. If i want to change it in the power query it says that i have to change them into other numbers. Can someone help me?

[JoeBarry · Accepted solution]

Hi @Elijabrnc 

Before trying to change, format the number as Text.

I would actually keep the number for sorting reasons and add a custom column. then when you load in the data, you can sort the custom column by the number and it will appear in the order you wanted in a visual

if [YourColumn] = 0 then "normal" else 
if [YourColumn] = 1 then "high" else "low"

Thanks

Joe

If this post helps, then please Accept it as the solution