From the course: Power BI Data Methods

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Using conditional functions

Using conditional functions - Power BI Tutorial

From the course: Power BI Data Methods

Start my 1-month free trial Buy for my team

Using conditional functions

“

- [Instructor] We can add rules-based logic to our data models using functionalities like conditional columns. The high-level logic of the conditional formula says that if condition one is met, then we return this result. Otherwise, if condition two is met, we return another result and so on. If none of the above conditions are met, then we return this alternative result. When we apply this logic to power query conditional formulas, these sections of the diagram match to our if then, else if then and so on until our final alternative catch all result of else. Like other formulas in Power Query, it's also case sensitive, so we need to write them out in lowercase letter clauses if we create conditional formulas manually. If we take a closer look at our hourly weather measurements for Santa Barbara that we obtained through the METAR API, the UTC date timestamp contains only the day, hour, and minute of the measurement. Earlier in this course, we used text formulas to extract the day…

Contents