Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

DAX Create Summary Table With Max Date
07-18-2023
01:14 PM
Hi all,
How can I create a summary table from a fact table that return only the Row with the Max Date for each set of criteria?
Here is what I have so far, but I I haven't been able to get just the Max Date.
Data Summary =
SUMMARIZE(
Data,
Data[Co],
Data[Division],
Data[Region],
Data[District],
Data[Center],
Data[Date],
Data[Amount]
)
Thanks
Thanks
-w
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2023
04:32 PM

Data Summary =
var a = SUMMARIZE(
Data,
[Co],
[Division],
[Region],
[District],
[Center],
[Date],
[Amount]
)
RETURN MAXX(a,[Date])
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2023
04:20 PM

Veja se ajuda
Tabela2 =
SUMMARIZE(
Tabela,
[Co],
[Division],
[Region],
[District],
[Center],
"Date", MAX(Tabela[Date])
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2023
04:32 PM

Data Summary =
var a = SUMMARIZE(
Data,
[Co],
[Division],
[Region],
[District],
[Center],
[Date],
[Amount]
)
RETURN MAXX(a,[Date])

Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
08-16-2024 12:23 AM | |||
07-24-2023 06:58 AM | |||
Anonymous
| 06-16-2020 02:31 AM | ||
11-07-2023 10:34 AM | |||
05-27-2024 03:26 PM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
85 | |
78 | |
41 | |
40 | |
35 |