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,

 

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