Join 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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi team,
How can I pick up only the LATEST DATE VALUES in the DATASET using DAX. Example below
Input:
| Customer | Value | Date |
| A | 25 | 30/06/2021 |
| B | 90 | 30/06/2021 |
| C | 45 | 12/04/2021 |
| D | 15 | 11/06/2021 |
Output:
| Customer | Value | Date |
| A | 25 | 30/06/2021 |
| B | 90 | 30/06/2021 |
Solved! Go to Solution.
Value total Latest Date : =
VAR _latestdate =
CALCULATE ( MAX ( Data[Date] ), REMOVEFILTERS () )
RETURN
CALCULATE ( [Value total :], KEEPFILTERS ( Dates[Date] = _latestdate ) )
Value total Latest Date : =
VAR _latestdate =
CALCULATE ( MAX ( Data[Date] ), REMOVEFILTERS () )
RETURN
CALCULATE ( [Value total :], KEEPFILTERS ( Dates[Date] = _latestdate ) )
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 60 | |
| 59 | |
| 45 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 115 | |
| 114 | |
| 38 | |
| 36 | |
| 26 |