Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Merge customers



We have the same customers that have accounts in the system.  We would like to make sure that Power Bi pulls a report based on the total of the same customer with multiple accounts.  Do we need to have a 'customer conversion' table to be able to merge or consolidate the records when building a Power Bi report.


In the example below, we would like to see just two (2) totals.  Customer #1 (ABC COMPUTERS + COMPUTER ABC + PC ABC) and Customer #2 (XYZ RETAIL + RETAIL INC.)







Community Support
Community Support

Hi @Oros 


You need to have a table to have a unique name for each customer and match the unique name to the multiple accounts it may have. Or is there any rule we can follow to add a new customer name column based on CUSTOMERS column? In this new column, we can have a unique name e.g. "Customer ABC" for "ABC COMPUTERS"&"COMPUTERS ABC"&"PC ABC" and "Customer XYZ" for "XYZ RETAIL"&"RETAIL INC.". 


After you have prepared above name-accounts matching, add unique name column and sales column into a table visual, you will have only two totals. 


Best Regards,
Community Support Team _ Jing

If this post helps, please Accept it as Solution to help other members find it.

Super User
Super User

@Oros  you need  a dimCustomer tbl for that-> create relationship with Fact->bring axis from dim->aggregate on fact


Customer Alpha Name Customer
a1 a
1a a

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

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors