HELP! How to sum most recent value in a matrix without dates

[edavis248]

Hi all-

I have contract data in a matrix in power bi. when the matrix is collapsed it is counting all 3 entries below. I need it to show only the latest value for contract 2 (2500000) and contract 1 (600000) for 3,100,000.

Contract #	Amount
	3100000	Total
1	600000
2	2000000
2	2500000

[edavis248]

Thank you, it almost works. Is there a way to still have it show the amounts that is is not suppsoed to add? it previously showed in the blank space the 2.354m amount. is it possible to still show that without counting it.

[amitchandak]

@edavis248 , for that you need to have date column or add an index column in the power query

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

Then you can have measure like

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...