Automatically Assign a Category to Uncategorized Rows in Power Query and DAX

Data Engineering Automatically Assign a Category to Uncategorized Rows in Power Query and DAX Sometimes we must assign a category to uncategorized data according to certain rules. Salvatore Cagliari Jul 20, 2026 11 min read Share Photo by Rodeo Project Management Software on Unsplash The Scenario One of my clients wanted to report on seat ownership. Each seat in the office building must be assigned to an organisational unit (OU). There is a list of all seats, and the owning OU should be set for each seat. But some seats don’t have an owning OU set. Therefore, they decided to assign all unassigned seats to the OU that owns the most seats. This must be done by room and by floor. Look at the following floor plan: Figure 1 – Example floor plan with unassigned seats (This is not a real one.

…

Excerpt limited to ~120 words for fair-use compliance. The full article is at Towards Data Science.