Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |