Concatenate values in Power Query M | Avoid these pitfalls!

Concatenating values is a fundamental skills when transforming data. And doing that is straightforward for text values. But doing so while mixing data types or including null values is a bit tricker. After this video, you will know what's important, and how to make your expressions error proof.

WRITTEN ARTICLE:

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUBSCRIBE TO MY CHANNEL

TIMESTAMPS
00:00 Introduction
00:27 Combining text
01:53 Combine text with delimiters
03:39 Using List.Accumulate
04:26 Combining null values
08:13 Working with dates

LET'S CONNECT:

Thank you for your support!

#concatenation #powerquery #m

[saurabhbhardwaj]

Thanks for posting this video. I really liked the way you explained concatenation basics using & operator and then went on to explain the power of Text.Combine with Text.From and Date.ToText functions. You also mentioned how user interface builds the formula for you if you use Merge Columns which is what I would typically do most of the times. But it probably won't accomplish what you demonstrated in the last example using specific string format for long date. I really look forward to seeing such amazing content from you in your future videos.

[odallamico]

Great tricks to combine data. Thank for sharing

[IvanCortinas_ES]

All this material is great. Thanks for sharing.

[mrbartuss]

Is the file available so we could follow along?

[gurvindersingharora]

Rick,
How to replace null values with List.Median through M Language?

[williamarthur]

Is there a way to get combiner functions to ignore nulls, so for example
Table.AddColumn(#"Added Custom", "Custom.1", each {"-", "/", "|"},
QuoteStyle.Csv)( { [A], [B], [Custom] } ))
it does ignore cells that are 'empty', might have it's uses but seems annoying.