Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Good afternoon!
I am having difficulty adding the debit that is a single CLIENT with the most recent date.
DATE; CLIENT; DEBIT;
03/03/2019; 30050; 554.20
03/15/2019; 30050; 300.28
03/19/2019; 30050; 300.28
03/07/2019; 28440; 254.65
03/17/2019; 28440; 458.74
Result:
03/19/2019; 30050; 300.28
03/17/2019; 28440; 458.74
Thankful,
Solved! Go to Solution.
Here's an option for a measure using variables
Most recent =
var c = selectedvalue('Table'[CLIENT])
var d = calculate(max('Table'[DATE]),'Table'[CLIENT]=c)
return calculate(sum('Table'[DEBIT]),'Table'[CLIENT]=c,'Table'[DATE]=d)
Here's an option for a measure using variables
Most recent =
var c = selectedvalue('Table'[CLIENT])
var d = calculate(max('Table'[DATE]),'Table'[CLIENT]=c)
return calculate(sum('Table'[DEBIT]),'Table'[CLIENT]=c,'Table'[DATE]=d)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 9 | |
| 8 | |
| 7 |