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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Need a help with combining data from two not connected tables.

Hello, 

 

I am a new user of Power BI. Can you please help me with the following question?

 

I have two customer tables with unique values. One has customer data of 2020 and the other has 2021. They are connected to the Program table. The program table consists of both 2020 and 2021  data. Customer tables are connected to the Program table but not connected with each other

 

I want to write a DAX measure or Column that can filter data (Like company Size) from both years. My aim is to find the total number of companies in both years and then apply a year filter. As both customer tables are not connected, so I am having difficulty combining them. would you advise me a way around? 

AsadChanna14_0-1626100319419.png


2020 _Cusotmer _Table 

Customer IDCompany Size
1Small
2Small
3Small
4Small
5Medium
6Medium
7Medium
8Large
9Large

 

2021_Customer Table:

Customer IDCompnay Size
1Small
2Small
3Medium
4Medium
5Medium
6Medium
7Large
8Large
9Large

 

Program_Table:

CI NumberProgramYear
1Financial2020
2Financial2020
2Non-Financial2020
3Financial2020
4Financial2020
5Financial2020
5Non-Financial2020
6Financial2020
7Financial2020
7Financial2020
8Financial2020
8Non-Financial2020
1Financial2021
1Non-Financial2021
2Financial2021
3Financial2021
4Financial2021
5Financial2021
6Financial2021
8Financial2021
9Financial2021

Thank you in advance,

Assad

1 ACCEPTED SOLUTION

@Anonymous ,
Delete or make those relationships inactive with that two customer tables and create a new one between Program table and the Union table.

View solution in original post

3 REPLIES 3
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @Anonymous ,

--First create an Year column in both the Customer tables:
   YEAR= "2020"
   YEAR= "2021"
Create a new table by doing UNION of both the tables...and then use this table.
UnionTble= UNION(2020 _Cusotmer _Table,2021_Customer Table)

 

This is how you cn combine them and proceed.

I hope this helps!

Anonymous
Not applicable

hi @Tanushree_Kapse 

 

after the union the customer's tables I will not be able to relate with program table as it will make many to many relation. Please advise

@Anonymous ,
Delete or make those relationships inactive with that two customer tables and create a new one between Program table and the Union table.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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