The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Community,
I am new to power bi and i am facing below issue, Please help me figure out.
I have 2 data sets One data set have 3 coulmn and 2nd data set have 5 columns. I want to compare both the data sets and if the record matches then copy the values from 2nd data set to 1st data set.
Dataset-1
Emp id, emp name, emp address
1 vamsi Hyd
2 Kiram Bengalore
Dataset-2
Emp id, emp name, emp address, emp ph, emp birthyear
1 vamsi Hyd 9848881482 1990
2 Kiram Bengalore 9871222124 1994
3 vamsi bengalore 1234567889 1987
I need output for data set-1 should be like below,
Output
EmpID, empName, emp address, emp ph, empbirthyear
1 vamsi Hyd 9848881482 1990
2 Kiram Bengalore 9871222124 1994
Thanks,
Paruchuri
Solved! Go to Solution.
@Anonymous,
Remove duplicates first, then you may use LOOKUPVALUE Function in DAX.
set the relationship on emp id and drop the column from respective tables in a table visual.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I have duplicate values in both tables so i can not create relation ship.
@Anonymous,
Remove duplicates first, then you may use LOOKUPVALUE Function in DAX.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
137 | |
99 | |
74 | |
60 | |
59 |
User | Count |
---|---|
263 | |
125 | |
115 | |
94 | |
79 |