DAX Create Summary Table With Max Date

Question

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(&nbsp; &nbsp; Data,&nbsp; &nbsp; Data[Co],&nbsp; &nbsp; Data[Division],&nbsp; &nbsp; Data[Region],&nbsp; &nbsp; Data[District],&nbsp; &nbsp; Data[Center],&nbsp; &nbsp; Data[Date],&nbsp; &nbsp; Data[Amount])Thanks-w

lbendlin · Accepted Answer

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

Forum Discussion

DAX Create Summary Table With Max Date

2 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

How to create a summary table

Create new summary table

creating a summary table