Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm a very new PowerBI user and just working my way through some of the courses offered Udemy, which may I add have been great so far 🙂
Anyway, I have an issue which I'm pretty sure is easy to do but I cannot find the information anywhere. I have two queries which are identical in row size and formats which I'm trying to merge into one query but only show exceptions.
For example in column A I have the numbers 1, 2, 3 and in column B I have the number 1, 2 therefore on the merged report I only want the number 3 to appear as the unique identifier. Is this possible?
I know I can do this easily in excel although I would like to get my BI skills up to scratch!
Thanks in advance and I look forward to using this forum.
Russell
Solved! Go to Solution.
Hi, @russelld
Based on your description, I created data to reproduce the scenario.
You may click 'Edit Query', go to Query Editor, choose 'Home' pane, select 'Merge Queries'.
Then you can configure as follows.
Finally you may expand Table(2) as follows.
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @russelld
Based on your description, I created data to reproduce the scenario.
You may click 'Edit Query', go to Query Editor, choose 'Home' pane, select 'Merge Queries'.
Then you can configure as follows.
Finally you may expand Table(2) as follows.
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the replies, 99% worked the reason for it not working perfectly was an issue on my data.
Thanks again.
Russell,
One way to do it is by using Merge queries.
Choose all the columns in two tables and use "Left Anti(rows only in first)" as Join kind.
As a next step, select "Choose Columns" and choose the desired columns( or uncheck Table column).
If this helps,mark it as a solution
Kudos are nice too.
@russelld are you referring to columns A and B, or these tables, Table A and Table B?? How you want output to be? Always check A and see what doesn't exists in B?
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.