Get startedGet started for free

Numeric transformations

You've been tasked with delving into the daily census dataset. Specifically, the operations team is looking to identify trends in patient flow by the effective date. In this exercise, you will need to compare the daily inflow (admissions) vs. outflow (discharges). Let's get to it!

Ch3_InflowOutflow.png

If you lost any progress, load the 3_3_numeric_transformation.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