Forum Discussion
Solved
Get Latest column Value
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.
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])
1 Reply
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])