Forum Discussion

Elijabrnc's avatar
Elijabrnc
Frequent Visitor
2 years ago
Solved

Change Number to a Word

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?

 

Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    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

1 Reply

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    2 years ago

    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