Find and replace overlap in Tables

Anonymous · ‎08-23-2019

Hi all,

I want to create a combined table. I have table A and table B. The endresult should be that whenever there is a corresponing row present in situation B it should overwrite or add to situation A resulting in table C. Any ideas how to achieve this result?

Thanks!

ImkeF · ‎08-23-2019

Hi @Anonymous

First you merge TableA with TableB on JoinKind.LeftAnti: This returns all rows that are present in TableA, but not in Table B (green part).

Then append that to TableB.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎08-23-2019