Forum Discussion
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.