CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Intermediate Power Query in Excel

Afficher le cours

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice