Summarize dates without blanks

Hey,

I use this kind of DAX statement:

Table = 
FILTER(
    ADDCOLUMNS( 
        SUMMARIZE(
            VALUES(Table1[Id])
            , Table1[Id]
        )
        , "the latest date" , CALCULATE(LASTNONBLANK('Table1'[LastEntryDate] , MAX('Table1'[LastEntryDate]) ))
    )
    , [the latest date] <> BLANK()
)

This creates a table like this:

As you can see from the screenshot from above, there really are no blank rows :-)

You have to be aware that you have to use TREATAS(...) if you want to use the summarized table as a table filter, as the calculation of the last date breaks the lineage to the column [LastEntryDate] like so:

a measure = 
var thesummarizedtable = ...
return
CALCULATE(
...
, TREATAS(<thesummarizedtable> , '<the table name>'[Id] , '<the table name>'[LastEntryDate])
)

Hopefully this is what you are looking for.

Regards,

Tom