Creating A Custom Text Cleaning Function In Power Query

Published: 02 January 2021
on channel: Enterprise DNA

6,188

155

Let's take a closer look at the custom function I created for Problem of the Week #2 to clean up the messy data. It is important to create this custom M function o you don't have to repeat creating one when the same logic is needed in the future.

Melissa

**** Relevant Links ****
Intro To Problem Of The Week #2 - • Create A Dimension Table From A Text ...

Create A Dimension Table In A Text File - Problem Of The Week #2 Power Query Solution - • Create A Dimension Table In A Text Fi...

**** Video Details ****
00:00 Intro
0:35 M code with myText parameter, invoke the function
2:00 removing unnecessary characters using Text.ToList
4:42 trimming the function
5:26 replace text value

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

Watch video Creating A Custom Text Cleaning Function In Power Query online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 02 January 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 6,188 times and liked it 155 visitors.