Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Managing Tables by Exceptions (differences in naming conventions)

Hi everyone, I'm willing to bet many of us have run into this before. I am working on building a cross functional report that looks across HR, Finance, Sales, Marketing, etc... The problem is, all of these groups define departments/teams in different ways. For example, HR calls our executive leadership team "Leadership" in all of their data, while sales just calls them "ELT". Additionally, some groups break down departments into various sub groups, while others roll them up. 


I've been searching for a solution to this, and stumbled across this video:


At the 5:58 mark, he discusses #5 "Not Managing by Exceptions" which seems like it would help in my situation. Problem is, he doesn't go into much detail, so i have no idea how to set up what he's referring to. Does anyone know how do this? How do you solve this issue of naming conventions within your own datasets?


I appreciate any help.


Thank you,



Re: Managing Tables by Exceptions (differences in naming conventions)

Hi @mike331 


It seems you may try to rename them in query editor.




Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors