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,



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

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors