Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi community,
How to Concatenate in M-query.?
I tried using Merge feature.
Tried using "&" too but didn't work!
I've three columns that I want to concat,
Day/Month/Year
Is there any way on how to do it using M-query functions?
Solved! Go to Solution.
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.
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.
@Niraj_vora0106
You can use Text.Combine({ first text, second Text,....}) and if you are combining any number keep that in " " for example "2" or "1" etc., and it works
Proud to be a Super User!
User | Count |
---|---|
139 | |
70 | |
68 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |