topic Re: Get Latest column Value in Developer

Get Latest column Value

pulikkan — Wed, 06 Jun 2018 18:30:18 GMT

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.

Re: Get Latest column Value

Greg_Deckler — Wed, 06 Jun 2018 19:19:46 GMT

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])