Combine newest date and related text-value in a measure

[max_mustermann]

My table_a looks as follows:

date	column1
01.02.2022	abc
05.03.2019	test
08.07.2005	test2

I just want to extract the newest date and the related text-value to a measure:

measure = MAX(table_a[date]) & " - " & table_a[column1]

But that does not work. I just want to get the following measure as a string:
01.02.2022 - abc

[Samarth_18 · Accepted solution]

Hi @max_mustermann ,

Please try this:-

Measure_3 = 
VAR _max_date =
    CALCULATE ( MAX ( 'Table (5)'[date] ), ALL ( 'Table (5)' ) )
VAR _text_by_max_date =
    CALCULATE (
        MAX ( 'Table (5)'[   column1] ),
        FILTER ( 'Table (5)', 'Table (5)'[date] = _max_date )
    )
RETURN
    _max_date & "-" & _text_by_max_date

BR,

Samarth