The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Advanced Concatenate/ Merge columns with Power Query

Concatenating columns in Power Query is not hard to do, but depending on the technique you use, you might get unexpected or wrong results.

Table of contents:

00:00 Intro & Problem description
01:19 How power query concatenates columns with Table.CombineColumns
02:40 Issues with nulls when concatenating using a custom column
04:00 Explain Text.Combine function in power query
04:17 The final pattern/ solution
05:00 Avoid errors with nulls in the new pattern

Watch the tutorial:

Advanced Concatenate/ Merge columns with Power Query

Links to the mentioned resources

Link to the null, blank video mentioned in this video:

If ISBLANK, NULL or EMPTY in power query
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents