Advanced Concatenate/ Merge columns with Power Query
93.2 هزار بار بازدید -
4 سال پیش
-
Concatenating columns in 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.
There is a bullet proof way to do it and I will explain it here.
Chapters:
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
Done!
Link to the null, blank video mentioned in this video:
If ISBLANK, NULL or EMPTY in power query
Here you can download all the pbix files: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
@curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB
#CURBAL #SUBSCRIBE
There is a bullet proof way to do it and I will explain it here.
Chapters:
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
Done!
Link to the null, blank video mentioned in this video:
If ISBLANK, NULL or EMPTY in power query
Here you can download all the pbix files: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
@curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB
#CURBAL #SUBSCRIBE
4 سال پیش
در تاریخ 1399/07/23 منتشر شده
است.
93,283
بـار بازدید شده