From the course: Power BI Challenges: 15 Skills-Building Analytics Exercises for Data Professionals

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Solution

Solution - Power BI Tutorial

From the course: Power BI Challenges: 15 Skills-Building Analytics Exercises for Data Professionals

Start my 1-month free trial Buy for my team

Solution

“

- [Instructor] So it seems that Landon hotels are mostly interested in two categories of country. They want North America and rest of world. So I'm going to create a new dimension by which we can filter or slice the data, and I'm going to call it region. The first thing I'm going to do is make a completely new tab and we can decide which of the two we like later and just delete the one that we like less. I'll call this one regions for now. So I'm going to start with the data and create a new column. And this is going to work out whether the country is in North America or the rest of the world. So we say region is, and then we have an if statement. If it is either the case that the country is, if either of those things hold true, then output me a region of North America, otherwise output me rest of world. Now press enter and let's see how it's doing. So if we just scroll down to where we've got a mixture, you see it seems to…

Contents