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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
