Get startedGet started for free

Debugging the advanced editor

Your teammate heard you were quite savvy with the Power Query Advanced Editor and sent you a script to test. They keep getting errors when they try to run it.

The query is meant to display a summary of % admission rate for all unfiltered emergency department visits by visit month.

Your challenge is to use the knowledge you've gained from M and the Advanced Editor to debug their query.

MonthlyAdmissionRateQuery.txt

If you lost progress, load the workbook 3_3_debugging_the_advanced_editor.xlsx from the Workbooks folder and launch the Power Query editor.

This exercise is part of the course

Intermediate Power Query in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise