Consolidating multiple data items into fewr choices

kierenjblake Hi! You can do this with a merge.

1. In Power Query:
Go to Home > Merge Queries

Select your Form responses table as the primary table.

Select your Mapping table as the secondary table.

Join them on the Department column.

Use a Left Outer Join (keep all from Form responses, matching from Mapping table)

2. Expand the Section:
After merging, click the expand icon on the new column (from your Mapping table)

Select only the Section column to add.

Rename it to something clear like Department Section

3. Close & Apply:
Load the data back into Power BI and you're set.

If you paste the advanced editors of the tables, i can fix your code.

BBF

💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!