Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |