Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert numbers into text

Hi, I have a column with 4 different numbers, lets call them 1111, 2222, 3333, 4444. For a diagram, I want them to be named, e.g. for 1111, should be named AAAA, 2222 should be named BBBB etc.   Wh...
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    What is the logic to give the names ?

    If you have it mapped in another table, you can just merge both tables and use this column.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous ,

 

 

Create a Calculated Column.


Column = 
SWITCH(
TRUE(),
'Table'[Column] = 1111 , "AAAA",

'Table'[Column] = 2222 , "BBBB",

'Table'[Column] = 3333 , "CCCC",

'Table'[Column] = 4444 , "DDDD"

)

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

 

thanks for that solution. It unfortunatley didn't worked out. Power Bi shows me the following message:

 

DAX comparisons do not support comparisons between text and integer values. You can use the VALUE function or the FORMAT function to convert one of the values.

But I think this is in general the right way to do it!

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous ,

     

     

    What is the Data Type of 1111 ?? Is it Text or Integer.

     

    Pls check and let me know.

     

    Can you share a screen shot if your table.

     

    Regards,

    Harsh Nathani