DAX Calc. Column with true/false entry only in latest instance per category

Question

I would need the fourth, calculated column, to the below ex. table. Category is 'case' and entry is in the latest 'date' record per category, based on the 'result' from the latest 'date'

Thanks!

Answer 1

final result = 

 VAR tbl = CALCULATETABLE('Table', ALLEXCEPT('Table', 'Table'[case]))
 VAR maxDate = MAXX(tbl, 'Table'[date])

 RETURN 
 IF('Table'[date] = maxDate,
    CONCATENATEX( 
        FILTER(tbl,  'Table'[date] = maxDate), 'Table'[result]
    ), ""
)