bring the SUM of Amount for the last value based on date and document number

[JEM_Systems]

Hi, I have some document number transaction that sometimes can bring the same value but in multiple dates, so I need to bring just the value for the last date the most recent, but I need to sum the most recent value for each document number, could someone help me?

[Ashish_Mathur]

Hi,

Create a Date column by using the following calculated column formula

Date= 1*("1/"&Data[Month]&"/"&Data[Year])

Create a Calendar Table with a relationship (Many to One and Single) from the Date column created above to the Date column of the Calendar Table.  To the Table visual, drag Document number column.  Write these measures

Amt = sum(Data[Amount])

Measure = CALCULATE([Amt],LASTNONBLANK('Calendar'[Date],CALCULATE([amt])))

[Ahmedx]

Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.