Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise