cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kolovez
Helper I
Helper I

Combine two tables (many to many relation problem)

Hi all,

 

I would like to see how many distinct A,B,C buying customers there have been in each month.

Then i want to see how many customer meetings have been booked per A,B,C customer in each month.

 

Finally i want to calculate:

number of meetings booked / number of distinct buying customers 

per country per month and per ABC category.

 

I have 3 tables

"Meetings" = Table with records of booked meetings with customers (22.000 rows)

"Buying Customers" = Table with records of each item order transaction (1.350.000+ rows) 

"SO Profit Category" = It's a table made for sorting purposes to order A,B,C customers. 

 

A,B,C customers are in the field: Profit Category

Business Unit and Country2 is the country name. They are 100% spelled same way in both tables. 

 

But i can't join these two tables as i want. And i don't know what to do to fix it 😞 

 

kolovez_0-1634298498782.png

 

kolovez_1-1634298756141.png

 

2 REPLIES 2
kolovez
Helper I
Helper I

Maybe i am approaching this problem incorrectly - its not about connecting tables? 

The customers don't necessarily have to be the same customers.

 

Its just number of meetings held with ANY A customer

divided by

number of meetings budget (which is same as number of distinct A buying customers per month per country).

 

So the specific customer don't matter only whether its an A, B or C customer and their country. 
 

amitchandak
Super User
Super User

@kolovez , Bring A,B,C customers from Profit Category to Customer, but that would only be one values

 

example : correct column names

 

Maxx(filter('Profit category', 'Profit category'[Business Unit] = customer[Business Unit] && 'Profit category'[Country2] = customer[Country]), [A,B,C customers])

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.