From the course: Power BI Data Modeling with DAX
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Use OR to handle case sensitivity - Power BI Tutorial
From the course: Power BI Data Modeling with DAX
Use OR to handle case sensitivity
- [Instructor] We have a calculated column in our data model that uses find to determine the position of the word mouse within a product name. And then uses if to place the word most in our calculated column, if there is indeed a mouse in the product name. The problem when you're using find is that find is case-sensitive. And there are two different ways you can deal with that, you could either convert for the purpose of comparison the string to either upper or lowercase. And do the same with the text that's in the product name. That's one option, is a text conversion to upper or lower case. For both of the items that we're comparing. The other possibility is if we know something about our product names. And we know that they are usually either lowercase or are proper case but never uppercase. Then we really have only two choices, we could look for capital M, mouse and all lowercase mouse. If either of those is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.