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.