Forum Discussion
Solved
Max or First Record when doing a Merge
I am doing a some table merging. However, I do not need all the records from the second table, I only need the first record or the max depending on the scenario. Can Merge accomplish this? If so wh...
Hi LarryAlx ,
While merging,select "left outer" as the Join Kind:
After that,go to append table and choose "Aggregate">select "Maximun" or "Minimum" of column "Contract Line Item":
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
I would do a Group By on the ID column on your Right Table, choosing Max as the aggregation on the line item column. You can then merge either table into the other.
Pat