Cannot convert value 'a863597160' of type Text to type True/False.

[Anonymous]

Hi All,

I'm trying to create a new column based on existing columns.

Column1 is having values like "a863597160"---data type text

Column2 ia having values like "14592"----datatype decimal number

When I'm trying to create a new column by concatenating the existing 2 columns I'm getting error like "Cannot convert value 'a863597160' of type Text to type True/False."

I have tried the same by changeing data type of column2 to Text still I'm getting sameerror.

Can anyone help me here to resolve this.

Thanks,
Anand

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

You could use the following dax :

Column = 'Table'[Column1]& "" &FORMAT([Column2], "General Number")

And you will get the below:

Wish  it is helpful for you!

Best Regard

Lucien Wang

[Vera_33]

Hi @Anonymous 

How do you want to concat them? Like this?

[Anonymous]

No, I'm concatenating them in formula bar not in transform data tab.

[Vera_33]

You mean DAX not M?

[Anonymous]

Yes in DAX not in M

[Anonymous]

But this helps thanks.