[Expression.Error] We cannot convert the value 20 to type Text.

[arvindyadav]

Hi Team,

I am facing some error like [Expression.Error] We cannot convert the value 20 to type Text.

How can I adjust to this?

I am working on excel files.

Regards,

Arvind

[Aron_Moore]

Sounds like you are trying to use some DAX expression which requires text, but the input contains numbers. You could try wrapping your input in FORMAT(table[column with text&num]), "" )

[arvindyadav]

Hi @Aron_Moore,

I did 3 column unpivot 1st it is in format of ABC/123 format after unpivot it is converted into 1.2 format .
If I am using what you said is that okay with my data .. I did unpivot in edited query.

Regards,
Arvind