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.
Hello all,
I need to create a table in Power BI that is a combination of 2 columns from 2 different tables, but it’s not really merge or append.
Table 1:
Emloyee ID | Employee Name |
1 | John Smoth |
2 | Maria Fernandez |
3 | Luca Still |
4 | Mateo Gill |
5 | Lucy Rensing |
6 | Sarah Li |
Table 2:
Training ID | Traiining Name |
1 | Project Management Basis |
2 | Quoting in QuoteBuilder |
3 | Excel Basics |
I should create something like this:
Index | Employee Name | Training Name |
1 | John Smoth | Project Management Basis |
2 | Maria Fernandez | Project Management Basis |
3 | Luca Still | Project Management Basis |
4 | Mateo Gill | Project Management Basis |
5 | Lucy Rensing | Project Management Basis |
6 | Sarah Li | Project Management Basis |
7 | John Smoth | Quoting in QuoteBuilder |
8 | Maria Fernandez | Quoting in QuoteBuilder |
9 | Luca Still | Quoting in QuoteBuilder |
10 | Mateo Gill | Quoting in QuoteBuilder |
11 | Lucy Rensing | Quoting in QuoteBuilder |
12 | Sarah Li | Quoting in QuoteBuilder |
13 | John Smoth | Excel Basics |
14 | Maria Fernandez | Excel Basics |
15 | Luca Still | Excel Basics |
16 | Mateo Gill | Excel Basics |
17 | Lucy Rensing | Excel Basics |
18 | Sarah Li | Excel Basics |
Is there any way to do this in Power Query?
Thanks in advance for help.
Solved! Go to Solution.
Hi,
you can find the solution in this article
https://learn.microsoft.com/en-us/power-query/cross-join
Look also a the attached file (there is also the crossjoin in Dax)
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Yes, this is it! Thank you so much!
Hi,
you can find the solution in this article
https://learn.microsoft.com/en-us/power-query/cross-join
Look also a the attached file (there is also the crossjoin in Dax)
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
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.