Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
3 years ago
Solved

DAX Create Summary Table With Max Date

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 t...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago
    Data Summary =
var a = SUMMARIZE(
    Data,
    [Co],
    [Division],
    [Region],
    [District],
    [Center],
    [Date],
    [Amount]
)
RETURN MAXX(a,[Date])
lbendlin's avatar
lbendlin
Super User
3 years ago
Data Summary =
var a = SUMMARIZE(
    Data,
    [Co],
    [Division],
    [Region],
    [District],
    [Center],
    [Date],
    [Amount]
)
RETURN MAXX(a,[Date])