Forum Discussion
Helper IIIConcatenation in M-query
To concatenate multiple values with "&", you need to ensure every value is of Text type. You can change all column types to Text before concatenating. Or if you want to keep their original non-Text type, you can use Text.From() function to convert column type temporarily when concatenating.
In the following example, Day and Year columns are of Whole number type.
Text.From([Day]) & "/" & [Month] & "/" & Text.From([Year])Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Community Support
To concatenate multiple values with "&", you need to ensure every value is of Text type. You can change all column types to Text before concatenating. Or if you want to keep their original non-Text type, you can use Text.From() function to convert column type temporarily when concatenating.
In the following example, Day and Year columns are of Whole number type.
Text.From([Day]) & "/" & [Month] & "/" & Text.From([Year])
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Helper III