Power Query Merge - take only first match

Hi kevinsa ,

I suggest you to add an [Index] column to sort your ID by [Item Number] and [Date] group in Right Table.

For reference:

Create Row Number for Each Group in Power BI using Power Query

After you merge two table by left out, you can expand [ID] and [Index] in Right Table. Add a filter on new table to only keep the index value = null or 1.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.