Split by Variable Columns in Power Query

Published: 22 April 2022
on channel: Goodly

30,087

1.2k

Check out our newly launched M Language course ↗️ - https://goodly.co.in/learn-m-powerquery/

The default Split by feature in Power Query produces a fixed number of columns. In this videos I'll share an interesting M technique to split by Variable Columns in Power Query. Enjoy!

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
https://goodly.co.in/learn-dax-powerbi/

✔️ Power Query Course-
https://goodly.co.in/learn-power-query/

✔️ Master Excel Step by Step-
https://goodly.co.in/learn-excel/

✔️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dash...

===== LINKS 🔗 =====
Blog 📰 - https://www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/
Need my help on a Project 💻- https://www.goodly.co.in/consulting/
Split by Delimiter Blog - https://www.goodly.co.in/split-by-var...

===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com

===== CHAPTERS =====
0:00 Intro
0:37 Split by Columns - The Problem
2:23 The Logic
4:22 The Solution
12:09 Testing the Solution
13:02 My Courses

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

- - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Source: https://goo.gl/fh3rEJ
Official After The Fall YouTube Channel Below
https://www.youtube.com/channel/UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: https://creativecommons.org/licenses

On this page of the site you can watch the video online Split by Variable Columns in Power Query with a duration of hours minute second in good quality, which was uploaded by the user Goodly 22 April 2022, share the link with friends and acquaintances, this video has already been watched 30,087 times on youtube and it was liked by 1.2 thousand viewers. Enjoy your viewing!