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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Zakaria_1980
Post Patron
Post Patron

Link two tbls

Hello,

 

i've two tables and the main data in both tbls is "Opporty Nb". 

in the first tbl, i've the following inputs:

 

Opporty NbPjt Nam.CaseIdCity
XXXXXXXXXXXXXXXXX

 

in the 2nd  tbl, i've the following inputs:

Opporty NbCreation_dateSubmission_dateApproval_date
XXXX/XX/XXXXXX/XX/XXXXXX/XX/XXXX

 

let's say that i want the following output:

 

Opporty NbPjt Nam.Creation_dateSubmission_dateApproval_date
XXXXXXXX/XX/XXXX XX/XX/XXXXXX/XX/XXXX

 

when i make the relatioship bw the two tbls by "Opporty Nb", i get my output tbl empty, whether i used the Opportyns Nb from tbl1 or Tbl2.

 

Thanks for your help to understand where is my error.

 

regards,

 

1 ACCEPTED SOLUTION
goncalogeraldes
Super User
Super User

Hello there @Zakaria_1980 ! Have you tried to do it with a Merge in Power Query? You can do so by using the "Merge Queries" option in the Home tab on Power Query and then selecting the common column (in your case "Opporty Nb"). 

goncalogeraldes_1-1643190096479.png

 

After this step you can selected which columns to expand (keep) in your merge:

goncalogeraldes_2-1643190182144.png

 

You can also remove any unnecessary column from the left of the merge to ultimately get the result you need! 

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

 

 

 

View solution in original post

1 REPLY 1
goncalogeraldes
Super User
Super User

Hello there @Zakaria_1980 ! Have you tried to do it with a Merge in Power Query? You can do so by using the "Merge Queries" option in the Home tab on Power Query and then selecting the common column (in your case "Opporty Nb"). 

goncalogeraldes_1-1643190096479.png

 

After this step you can selected which columns to expand (keep) in your merge:

goncalogeraldes_2-1643190182144.png

 

You can also remove any unnecessary column from the left of the merge to ultimately get the result you need! 

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

 

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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