Display the same row as value and not the sum of full column

[Bondeuz]

Hi,

I am having trouble displaying the same quantity in column G when displaying the "latest" date from column A. It can only show me the sum of column G.

In the screenshot below you can see that it shows me the latest posting date of this SKU correctly, but as quantity it shows me the sum of column G. I would only like to display the value from column G in the same row as it took the posting date from column A.

A	B	C	D	E	F	G	H	I
2022-11-11	Purchase	105020	10029-3	SLS BMG Hinge Righthand	L1304	-8	-128	0
2022-11-11	Purchase	IB100863	10029-3	SLS BMG Hinge Righthand	L1304	500	0	8012,63
2022-09-29	Purchase	IB100644	10029-3	SLS BMG Hinge Righthand	L1304	300	0	5280
2022-08-29	Purchase	105007	10029-3	SLS BMG Hinge Righthand	L1304	-3	-54	0
2022-08-29	Purchase	IB100446	10029-3	SLS BMG Hinge Righthand	L1304	100	0	1799,44
2022-08-12	Purchase	IB100370	10029-3	SLS BMG Hinge Righthand	L1304	500	0	8929,05
2022-07-07	Purchase	105002	10029-3	SLS BMG Hinge Righthand	L1304	-4	0	-71,39
2022-06-07	Purchase	IB100012	10029-3	SLS BMG Hinge Righthand	L1304	500	0	8012,64
2022-06-01	Purchase	IB100004	10029-3	SLS BMG Hinge Righthand	L1304	315	0	5621,98

[amitchandak · Accepted solution]

@Bondeuz , same if these can help

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.