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])
VilmarSch's avatar
VilmarSch
Post Partisan
3 years ago

Veja se ajuda

 

Tabela2 = 
SUMMARIZE(
    Tabela,
    [Co],
    [Division],
    [Region],
    [District],
    [Center],
    "Date", MAX(Tabela[Date])
)