Categorize Data with Ease - Find Substring Matches with DAX in Power BI

Описание: In this video, I'll show you how you can categorize your data by finding specific keywords/substrings or characters in your dataset with SWITCH TRUE in DAX. This method is much simpler and effective than Excel and PowerQuerys Multiple IF functions is perfect if you have unstructured datasets that needs a good bit of cleaning and categorization.

0:00 - Advantages of using SWITCH TRUE with DAX
0:42- How to Find Keyword/Substring in Strings and Categorize with DAX

##DataCleaning, #KeywordExtraction, #SubstringMatching

Music:
Motivational Ambient | ALONE by Alex-Productions |    / @alexproductionsnocopyright  
Music promoted by https://www.chosic.com/free-music/all/
Creative Commons CC BY 3.0
https://creativecommons.org/licenses/...