Aan de slagGa gratis aan de slag

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.

Deze oefening maakt deel uit van de cursus

Intermediate Power Query in Excel

Cursus bekijken

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen