How to Filter distinct values of a column using latest date?

[Anonymous]

Hi all,

I need to get the list of distinct values filtered by the latest date of the date column of another table. Can you please suggest a way to do this?

Thank you

[Arul]

@Anonymous ,

based on your input I have created one sample table with date and name column and created measure to find the distinct names for the latest date from another table.

Distinct Names = 
VAR _tempTable =
    FILTER ( 'Table1', 'Table1'[Date] = MAX ( 'Table2'[Date] ) )
VAR _result =
    CONCATENATEX ( DISTINCT ( _tempTable ), 'Table'[Name], "," )
RETURN
    _result

Ouput:

Thanks,

Arul