custom column

[thoms1]

Hi,

I'm struggling with adding a custom column which should CONCATENATE Field A with Field B in the Query Editor.

Whenever there is either a number or a Date Time value in one of the fields, I get the following error message:

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

It works well with the Merge Columns function, though. I can also add custom columns with calcuations on numbers in Fields A and B. The format of the custom column has no influence on the error state.

Any idea how to concatenate fields with number values in a custom column?

Thanks

Thomas

[MarcelBeug · Accepted solution]

= Text.From([Field A]) & Text.From([Field B])