Power Query MERGE Challenge Solution - DUPLICATES Alert 

You're welcome Andrew. Thanks for taking the time to leave a kind comment

You're welcome :)

Cheers Steve

Cheers. I appreciate you taking the time to let me know you found it useful

Glad it helps. Thanks for taking the time to leave a kind comment.

Cheers Kebin

You’re welcome

Yep, good call Ryan. I actually used > 1 in my final solution file that is linked in the comments. The 1 option might be a good solution for flagging duplicate OR missing dimension codes...🤔

Maybe one A has a space before /after it or something different about it. Uppercase lower case can impact too

Sounds more like something suitable to Fabric and a warehouse

I don't think so, although .buffer is a dark art. I don't think it fits here

@@AccessAnalyticI used Buffer before and I remember it's a list in memory for faster processing.

It will prevent multiple calls to the source. If I don’t think that applies here

@@AccessAnalytic Thank you for clarifying my query.

Thanks. When adding the custom row count column you could wrap it in an IF > 1 then Alert else null

@@AccessAnalytic You mean at the very end?

Around the 6:07 mark, wrap the row count formula in an if statement

Hi , at 13:40 in the final step I use MaxCount in the IF

Sounds like something that requires some further explanation and example / screenshots. I recommend posting to techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat?WT.mc_id=M365-MVP-5002589 or community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

Easy when you know how ! 😆

Cheers Orlando

😆

Nice Geert

It's amazing how many different approaches people took in their submissions. Glad mine was logical.

@@AccessAnalytic What I meant to say was: this challenge was not the most difficult one to date. BTW: this challenge did show (again) the versatility of Power Query: Power Pivot could not handle this, needing a unique primary key in the dimension table. Also, merging tables based on multiple columns is something PP can’t do. In that sense PQ is the most robust. Yet another reason why we like PQ so much. :-)

Indeed!