11.5 Left, Right and Mid Functions in Power BI (Power Query) | Power BI tutorial for beginners

#pavanlalwani #powerbi #businessintelligence #dataanalytics #powerquery #datavisualization

Are you a beginner, learning how to work with left, right, and mid functions in Power Query? In this tutorial, I'll show you how to use these functions without using the keyboard, just by using button clicks.

I have an example table with a column named "Order ID," which contains data in the format "CA-2018-some number." If you want to split this column into separate parts or extract specific text, such as left, right, or middle text, this tutorial is for you.

I'll walk you through the steps using a practical example in Power BI. We'll load two tables, one with consistent data and the other with text containing delimiters. I'll demonstrate how to extract the first two characters, the last six characters, and the middle text from the given column.

You'll also learn about the difference between using the "add column" and "transform" options. It's essential to understand when to use each option to extract specific text accurately.

If you're ready to level up your Power Query skills and master the left, right, and mid functions, watch this tutorial now. Don't forget to like, comment, and subscribe for more useful Excel and Power BI tutorials!
----------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:

📚 200+ MCQs to test your knowledge.
📝 20+ Assignments for hands-on practice.
🔍 11+ Case Studies for real-world insights.
💼 5+ Industry Projects to build your portfolio.
🎓 Course Completion Certificate for your resume.
💡 Tips & Tricks to boost your skills.
🔎 5+ Industry Datasets for practical learning.

Join thousands of professionals who have transformed their careers. Enroll now at 50% off!

You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX

Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"

Don't forget to use the hashtags #powerbi 📊 #midfunctions 📈 #datacleaning 👨‍💼
----------------------------------------------------
Timestamps:

00:08: Using Buttons for Functions 💡
01:15: Previewing Data Before Picking Tables 📊
01:59: Extracting First Two Characters 🗂️
03:26: Difference between Add Column and Transform 💡
04:03: Extracting Last Six Characters 🗃️
04:29: Getting Middle Text 📝
05:02: Limitations of Left, Right, and Mid Functions ❌

[PavanLalwani]

🚀 Calling all data enthusiasts! 💼🌟

👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!


💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼

[mukulmanav]

The way you explain things is very nice and on top of that the method of creating short video for each topic is a great idea.

[Maria-usph]

Hi Pavan...Thankyou for the well explained videos on powerbi...Could you please make some videos on tableau prep for the data cleansing part

[nirmalKUMAR-ylcw]

Hi pavan, is there a lookup relation between the sheets or tables in the excel which we load in power BI? or there need not be relation i.e. random tables can be loaded in query and reports could be created after cleaning!

[bhatti.]

Pavan Sir your videos are really usefull...Plz after this teach R programming course

[memorizeitall]

Thank you for a lot of useful videos. I like your expression "very simple" :-)

[SonuPandey-mefs]

Great ! Difference between Transform Vs Add Column

[bandaralqahtani]

THank you Pavan
but what if I have numric column, is thast possible to use LEFT and Right functions with it?

[Jayaprakash_]

Hi sir, please can u do with real time projects ?

[parshuramroy]

Download Material and PBIX file is not opening

[caushaljee]

sir good evening tell me bussines details