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/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 #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial