LESSON 10080 | LEN, LEFT, RIGHT, MID: TEXT FUNCTIONS IN DAX | Free Course

In this video, I walk you through how to effectively use four essential DAX text functions in Power BI—LEN, LEFT, RIGHT, and MID—to manipulate and extract data from text fields in a products table. I explain not just how each function works individually, but also how they can be combined in calculated columns to isolate product information dynamically, such as trimming brand names or isolating substrings from product labels. You’ll learn the importance of row context, how to avoid hardcoded values when working with varying string lengths, and how to apply logic that adapts to each row in your dataset. Whether you're cleaning product names or preparing columns for analysis, these DAX functions are key tools for shaping your data in Power BI.

📈 Get the data packs: https://immalytics.com/packs?utm_source=daxfoundations10080

🟣 DAX Foundations Playlist: 👉🏻 https://www.youtube.com/playlist?list=PLnm1yN9FxLe6HhAF3NyS2_gxFMqK1H7aU
🟢 Power Query Fundamentals Playlist: 👉🏻 https://www.youtube.com/playlist?list=PLnm1yN9FxLe4HEUtaczH4HsYQhfX5YlVy
🟡 Power BI Playlist: 👉🏻 https://www.youtube.com/playlist?list=PLnm1yN9FxLe4lC7ZJKDt7TMUAZKJ5VOFi

💻 For all playlists, visit our website: https://immalytics.com

Chapters
00:00 Four Essential DAX Text Functions in Power BI
00:06 Introducing LEN, LEFT, RIGHT, and MID functions
01:21 Overview of the product table and working in calculated columns
02:00 Applying LEN function to count characters dynamically
02:56 Using the LEFT function to extract characters from the beginning
04:40 Applying the RIGHT function to extract characters from the end
06:37 Demonstrating the MID function to extract text from the middle
09:01 Combining LEN and RIGHT to remove brand names dynamically
11:27 Final results and confirming the transformation logic

#dax #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse #sql #sqlserver

Видео LESSON 10080 | LEN, LEFT, RIGHT, MID: TEXT FUNCTIONS IN DAX | Free Course канала I'mmalytics