Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm new to Power BI, and I want to do a "keep join" in Power Query Editor, for example, what I have is :
Table1:
ID |
1 |
2 |
3 |
4 |
5 |
6 |
Table2:
ID | Value |
1 | 10 |
3 | 20 |
3 | 15 |
4 | 30 |
6 | 40 |
6 | 50 |
8 | 60 |
9 | 70 |
10 | 60 |
I want to change the Table 2 to: (just based on the table1.id)
ID | Value |
1 | 10 |
3 | 20 |
3 | 15 |
4 | 30 |
6 | 40 |
6 | 50 |
How to solve that?
Thanks.
Aiolos Zhao
Proud to be a Super User!
Solved! Go to Solution.
I got the answer, just use right outer join.
Proud to be a Super User!
I got the answer, just use right outer join.
Proud to be a Super User!
Anyone can help to solve this question?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |