you can actually use blending here. Bring Profit as primary data source and Edit the Relationships and make ID as the linking field.

I am suggesting blending because joins in your case will duplicate the amounts and you will have issues in bringing the correct amounts.

Hi Jhanvi

Use Blending , ID as linking Field.

Here i have attached workbook for you.

Hi, Jhanvi

Here is another way of using join as shown below by key id =id

And then for sales, use sum as aggregation, and for profit, use average as aggregation

Workbook attached.

Hope this helps

ZZ

Hi, Jhanvi

It is a data join, not blend. and using which type of join will depend on your demand, they all should work.

ZZ