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 World,
I have this 2 Excel file.
1. Final Dataset
2. Lookup Dataset
I want to merge 2 columns from Lookup dataset to my final dataset file. I want to bring transaction date from lookup dataset to my final dataset. I got agrrement number in both my dataset.
I went to transform data, merge queries (Selected Final Dataset) as new. Then I selected my Lookup dataset and did Left Outer Join. I selected agreement number for matching column. The selection matches 67654 of 107078. I hit ok. I then brought the transaction date in the merged dataset.
But the problem now is, in merged dataset, the count of row is 392,681.
When my Final dataset actually just have 107,078 rows.
Now the merging doesn't makes sense. It's giving me all wrong analysis.
Hi @Timbuktu7 ,
Please check the lookup file in case it has multiple rows for the same join key.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos!
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |