11.0 Text Functions in Power BI (Power Query) | Power BI Tutorial for Beginners | By Pavan Lalwani

Опубликовано: 31 Июль 2020
на канале: Pavan Lalwani

110,825

495

#pavanlalwani #powerquery #textfunction #dataanalytics

In this video, we will explore various text functions in Power Query. Text functions are essential when you want to clean up your data. We will cover several functions, including how to merge two different columns without any code, split columns and remove unwanted spaces using Trim, upper and lower case formatting, adding a prefix and suffix, and working with left, right, and mid functions to extract text with delimiters. All of these features are accessible through button clicks on Power Query, and we will show you how to use them with ease.

If you are familiar with Excel, then Power Query is 70% easier than Excel, without the need to write any code or functions. Most of your tasks can be done using button clicks.

Join us in the video as we illustrate various examples of how to work on text functions in Power Query without using your keyboard.
---------------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:
🔗 https://learn.pavanlalwani.com/course...

📚 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!
🎉🔗 https://learn.pavanlalwani.com/s/store
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX
🎉 🔗https://learn.pavanlalwani.com/course...

Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"
📥 Download Practice Material from Server 💾:

#datacleaning #businessintelligence #powerbi
---------------------------------------------------------
Timestamps:

00:08 Introducing Power Query Text Functions 💬
00:23 Merging Columns without Code 🔄
00:32 Splitting Columns and Removing Spaces ⏬
00:39 Transforming Text Case 🔠
00:42 Adding Prefix and Suffix to Text ✒️
00:53 Extracting Text with Delimiters 📚
01:07 Emphasizing Button Clicks for Simplicity 💪
01:15 Power Query: 70% Easier than Excel 💼
01:26 Practical Demonstration of Text Functions 📝