Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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])
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])
User | Count |
---|---|
13 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |