How To Extract Values Before A Specific Text

For this tutorial, I’m going to showcase how you can extract values before each occurrence of a specific text. There are many ways to achieve that, but I thought it would be fun to show a solution that’s fully coded.

Melissa

**** Video Details ****
00:00 Introduction
01:03 Sample query
01:14 Custom column
01:28 Text.Split
02:26 List.Transform
03:16 Advanced Editor
04:21 Finding positions
06:41 Removing zeros
09:30 Getting strings
11:28 Results

**** 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...

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial