Filter table with calculated table

Hi Applicable88 
For table you can use

Last Data = 
VAR DataWithLastDatePerCategory =
    ADDCOLUMNS ( 
        Data,
        "@LastDate",
        VAR CategoryTable =
            CALCULATETABLE ( Data, ALLEXCEPT ( Data, Data[Category ] ) )
        RETURN
            MAXX ( 
                CategoryTable,
                Data[Date]
            )
    )
VAR Result =
    FILTER ( DataWithLastDatePerCategory, Data[Date] = [@LastDate] )
RETURN
    SELECTCOLUMNS ( Result, "Category", [Category ], "Date", [Date], "Name", [Name] )

for Calculated column you can use

Name On Last Date = 
VAR CategoryTable =
    CALCULATETABLE ( Data, ALLEXCEPT ( Data, Data[Category ] ) )
VAR MaxDate =
    MAXX ( 
        CategoryTable,
        Data[Date]
    )
VAR Result =
    MAXX (
        FILTER ( CategoryTable, Data[Date] = MaxDate ),
        Data[Name]
    )
RETURN
    Result 

Applicable88 Try with: