Creating A Custom Text Cleaning Function In Power Query
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 without registration, duration hours minute second in high quality. This video was added by user Enterprise DNA 02 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,188 once and liked it 155 people.