Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I have another question concerning the same dataset as in my post two days ago. I found the all-time max speed of the racers with the following DAX formula (big thanks to the MS Power Bi community!). I am able to report each unique max value in my daiiy report with a date filter.
Max Sp-ALL-TIME :=
IF (
[Max Sp-DAILY],
CALCULATE (
MAX ( fData[Max Speed] ),
FILTER ( ALL ( dDate ), dDate[Date] )
)
)
I am now trying to report (daily) the date of each individual all-time max (with a date filter). The following solution was found inside the comments section of a Power Pivot Pro blog post written by Reid Havens. Without a date filter the output is perfection. Unfortunately when reporting values for a specific date the solution falls apart for me.
Max Sp-MAX Date :=
IF (
NOT ( ISBLANK ( [Max Sp-DAILY] ) ),
MAXX (
TOPN (
1,
ADDCOLUMNS ( VALUES ( dDate[Date] ), "MAX SPEED DATE", [Max Sp-DAILY] ),
[MAX SPEED DATE]
),
dDate[Date]
)
)
The output with a date filter is on the left, and without a date filter on the right.
Thank you all in advance for the assistance!
Solved! Go to Solution.
Thank youu @wdx223_Daniel! I should have used your reply from my previous post as a reference!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
11 | |
11 | |
8 | |
8 | |
8 |