how generate a calculated column with max date1 for each label

[Anonymous]

label     DATA1                  NEEDED COLUMN

A           01-01-2023          10-01-2023

A           05-01-2023          10-01-2023

A           10-01-2023          10-01-2023

B           03-01-2023           08-01-2023

B           08-01-2023           08-01-2023

how can i generate a calculated column (the  needed column) with max date1 for each label

[Avantika-Thakur · Accepted solution]

Hi @Anonymous ,

Can you try creating a DAX column with the below formula

Max date = calculate(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[label]))

Hope this helps!

Please accept the solution if this answers your query.

Thanks,

Avantika Thakur