Forum Discussion
Helper INew table from two tables with condition
Hey lynnsop ,
I would do the work all in Power Query. The joins that you want are already available and you won't have additional tables in the data model that you don't need.
Please find my example file here:
https://www.swisstransfer.com/d/9387d28f-e05e-436e-9151-3de28ad519fd
For your first case, you only have to do an inner join:
For the second case you have to do a "left anti":
And that should already give you the result you want.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Most Valuable ProfessionalHey lynnsop ,
I would do the work all in Power Query. The joins that you want are already available and you won't have additional tables in the data model that you don't need.
Please find my example file here:
https://www.swisstransfer.com/d/9387d28f-e05e-436e-9151-3de28ad519fd
For your first case, you only have to do an inner join:
For the second case you have to do a "left anti":
And that should already give you the result you want.