Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Kapilchauhan555
New Member

Joins in tables to create new table visual

I have 2 tables table1 and table2, i want to create a new table visaul as described below

 

The combination of type and car is unique for each rows.

 

 Table1
Unique Cobination-->TypeCarCountSalesman
 DieselDzire1Ram
 Petrolxl62Rajan
 Hybridswift3Rita
 DieselThar3Rita
 PetrolRapid2Ram
 HybridThar1Rajan

 

 

Table 2
Unique Chesis#CarType
1DzireDiesel
2TharDiesel
3TharDiesel
4TharDiesel
5xl6Petrol
6xl6Petrol
7RapidPetrol
8RapidPetrol
9swiftHybrid
10swiftHybrid
11swiftHybrid
12Thar

Hybrid

 

 

 

Desired table
Unique Chesis#Salesman
1Ram
2Rita
3Rita
4Rita
5Rajan
6Rajan
7Ram
8Ram
9Rita
10Rita
11Rita
12Rajan
1 REPLY 1
Dhairya
Super User
Super User

Hey @Kapilchauhan555 
Please follow the below steps to achieve the expected output

Step1: Create a calculated column in both table

Dhairya_1-1694861827077.png

 

Dhairya_0-1694861811037.png


Step2: Configure the relationship from table1 to table2 based on newly calculated columns

Dhairya_2-1694861907278.png


Step3: Plot the required columns

Dhairya_4-1694861960115.png

You will get the expected output.

If it works then please mark my solution as accepted and kudo the post so that others can find it quickly while facing a similar issue. Thank You!


 



Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.