From the course: Power BI Data Modeling with DAX
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Use FIND - Power BI Tutorial
From the course: Power BI Data Modeling with DAX
Use FIND
- [Instructor] Now we're going to work a little bit with some of the logical functions. If you're used to working in Excel, you're used to functions like if, and, or, and so on. We'll begin by using a logical function find, which allows us to find a sub string within another string. And specifically we're going to use that to find mice in our product list. Rather than creating this as a measure, I'm going to go to the product table and I'm going to create this as a new column. And we're going to call the column mouse and say that mouse is equal to find, and here we have our assistance. The first thing we want to find is text. This is case sensitive. Mouse throughout this table starts with a capital M. So there's mouse within the text. And in the product table we're looking in the product name. The start position is one, and the report back on this will be similar to the sub string function in Excel. So if mouse is the…
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.