Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Power Query To The Max – Splitting Multi-Lined Excel Cells In Power BI

Posted on by Annie D

In this video, I want to show you one way of how you can split multiline cells into multiple rows. Sometimes you’ll get an Excel file where data inside the cell is split across multiple lines, and that can be painstaking to work with. I’ll demonstrate how you can use Text.Split and List.Zip in a case as such.

Melissa

***** Video Details *****
00:00 Introduction
00:57 Carriage return and line feed
02:07 Splitting cells into multiple list items
04:13 Creating a set of value pairs
05:53 Projection
08:02 Splitting columns by delimiter

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

Enterprise DNAWed, August 25, 2021 7:46pm