Get startedGet started for free

Multiple fields to investigate

The graph from the previous exercise is great, but there are more fields that we need to investigate. In order to do this, we might need to do some alterations for specific columns.

In this exercise, you'll learn how to use the function SWITCH() which allows you to create a new column by assigning new results to the values in a column. This way you can easily create new groups for categorical fields.

We do not recommend doing so, but if you lost progress you can load the solution report of the previous exercise 2_3_inspecting_groups_solution.pbix from the Exercises folder.

This exercise is part of the course

Case Study: Analyzing Customer Churn in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise