Calculate Sales for the last date of each item

[Syndicate_Admin]

Good! I have a query, I need to calculate the total amount you have for the last update of each bank. I used a calculate with lastnonblank to bring the last amount and also the last update (columns of the table), but in the total it calculates only the values that contain some modification in the last update (17/4 17:08:29), and not the amount of all as I really want.

I would like to correct this in the table, and also show the total amount of all banks.

Greetings and thanks!

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Measure = SUMX(VALUES(Data[Banco/Entitad]),[Monto])

My assumption is that Monto is a measure that you have written.