Grouped index columns
The pharmacy team has sent a new data file with all the medication information collected for each patient who visited the emergency department. It includes each PatientID, the types of medications they are using, and the total medications for each.
Your task will be to enhance this dataset by adding a grouped index medicationrankID to count unique medication types for each PatientID, sorted by top medication type by total medications.
If you lost progress, load the workbook 2_4_grouped_index_columns.xlsx
from the Workbooks folder and launch the Power Query editor.
Cet exercice fait partie du cours
Intermediate Power Query in Excel
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
