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