Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
Solved! Go to 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.
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!
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
9 | |
9 |