Convert numerical columns in strings and Concatena...

Anonymous · ‎11-13-2019

Hi everyone,

how can I convert 3 number columns in 3 string columns and then concatenate them together?

The function 'concatenate' only allows two columns, and the '&' operator does not work with numeric columns.

Thank you

Roberto

Anonymous · ‎11-13-2019

@Anonymous
Please try this. Will work even if you don't convert to text or else use format to convert int to text

Column = CONCATENATE('Table'[column1],CONCATENATE('Table'[column2],'Table'[column3]))

Convert numerical columns in strings and Concatenate them together