Multiple column transformations
The operations team is pleased with the insights you've given them so far!
Now, they want more information on average occupancy and how the values trend over time. This will help them understand which months of the year generate higher workload pressure.
In this exercise, you will leverage your knowledge of numeric, text, and date/time transformations to get them the necessary insights. Let's get started!
If you lost any progress, load the 3_4_multiple_column_transformations.xlsx
workbook from the Exercises folder and open the Power Query editor.
This exercise is part of the course
Introduction to Power Query in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
