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

[Anonymous]

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? 

2020 _Cusotmer _Table 

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

2021_Customer Table:

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

Program_Table:

CI Number	Program	Year
1	Financial	2020
2	Financial	2020
2	Non-Financial	2020
3	Financial	2020
4	Financial	2020
5	Financial	2020
5	Non-Financial	2020
6	Financial	2020
7	Financial	2020
7	Financial	2020
8	Financial	2020
8	Non-Financial	2020
1	Financial	2021
1	Non-Financial	2021
2	Financial	2021
3	Financial	2021
4	Financial	2021
5	Financial	2021
6	Financial	2021
8	Financial	2021
9	Financial	2021

Thank you in advance,

Assad

[Tanushree_Kapse]

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]

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

[Tanushree_Kapse · 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.