In this quick video, we'll be using the DAX LEFT, RIGHT, MID, SEARCH & LEN functions to simply and dynamically extract characters from Asset IDs. These functions are transferrable and can be used for all varieties of character strings.
This can also be achieved using Power Query, but sometimes DAX is your only option and therefore, a fundamental skill to have in your Power BI toolkit!
🤝 Visit my Website:
matadorsoftware.me/
🤝 Connect with me on LinkedIn:
linkedin.com/in/ja376
Please Like, Subscribe, Comment & Share if you enjoy!
- Extracting Characters from Power BI Strings using DAX Text Functions | LEFT/ RIGHT/ SEARCH & More! ( Download)
- LEFT & RIGHT DAX Function in Power BI. #How to extract desired string characters in any column. ( Download)
- Power BI LEFT, MID, RIGHT, LEN, FIND functions ( Download)
- DAX Fridays! #172: LEFT, RIGHT, LEN, SEARCH - Split text by character in DAX ( Download)
- 11.5 Left, Right and Mid Functions in Power BI (Power Query) | Power BI tutorial for beginners ( Download)
- Extracting substring using DAX in Power BI ( Download)
- How to use CONCATENATE / LEFT / MID / RIGHT / LEN / SEARCH / REPLACE DAX functions in Power BI ( Download)
- DAX Language - LEFT, RIGHT and MID Functions in Power BI ( Download)
- LEFT, RIGHT, MID, LEN - DAX Guide ( Download)
- DAX | Power BI | TEXT | FIND, SEARCH, LEFT, MID & RIGHT Functions ( Download)
- 11.6 How to Extract Text with Delimiters in Power BI (Power Query) | By Pavan Lalwani ( Download)
- Most useful TEXT function DAX you need | Power BI ( Download)
- How to extract text with an if condition in one step in Power Query ( Download)
- How To Parse Text With DAX ( Download)
- 15.4 How to Use LEFT, RIGHT, MID Text Functions in DAX | DAX in Power BI ( Download)
