Expression.Error: We cannot apply operator & to types Number and Text

Hi Tanmaub8055 

It might be a data type issue. Note that the Combination operator (&) is suitable for the following scenarios:

1）Text concatenation

2）List concatenation

3）Record merge

For more information, please refer to:

Operators - PowerQuery M | Microsoft Docs

So, if the data types are Number and Text, you will get the following error: We cannot apply operator & to types Number and Text.

The solution is very simple, please convert all data types to text.

And you can use operator (&) normally.

^{Best Regards,}

^{Yadong Fang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}