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:
https://gorilla.bi/power-query/concat...
I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
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:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#concatenation #powerquery #m