Get Latest column Value

[pulikkan]

we are trying to find the LoanAmount value on the latestAppDate. If we use filter to select IsApproved = 'Yes' then table contains 2 rows with AppDate as 01-Jun and 03-Jun in this case i need  Loanamount as 110(latest is 03-Jun) similarly, if i select filter IsApproved = 'No',  we expect LoanAmount value as 90. Appreciate your help on this.

[Greg_Deckler · Accepted solution]

You could create a VAR that does something like:

Measure = 
VAR __maxDate = MAX('Table'[AppDate])
RETURN ...

For the RETURN portion, you would use your __maxDate in a FILTER or something similar like:

Measure = 
VAR __maxDate = MAX('Table'[AppDate])
RETURN SUMX(FILTER('Table',[AppDate]=__maxDate),[Loanamount])