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,
i've two tables and the main data in both tbls is "Opporty Nb".
in the first tbl, i've the following inputs:
Opporty Nb | Pjt Nam. | CaseId | City |
XX | XXXX | XXXXXX | XXXXX |
in the 2nd tbl, i've the following inputs:
Opporty Nb | Creation_date | Submission_date | Approval_date |
XX | XX/XX/XXXX | XX/XX/XXXX | XX/XX/XXXX |
let's say that i want the following output:
Opporty Nb | Pjt Nam. | Creation_date | Submission_date | Approval_date |
XX | XXXX | XX/XX/XXXX | XX/XX/XXXX | XX/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,
Solved! Go to Solution.
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").
After this step you can selected which columns to expand (keep) in your merge:
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
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").
After this step you can selected which columns to expand (keep) in your merge:
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
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 |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |