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.
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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
