select last date without duplicates

[HoScho]

Hallo everybody!

If got a column "Name" an a column "DateTraining"

Name1	01.01.2022
Name2	02.02.2022.
Name1	03.03.2022
Name2	04.04.2022
Name3	10.10.2021

The Return has to look like this: (show the LatestDate of DateTraining)

Name1	03.03.2022
Name2	04.04.2022
Name3	10.10.2022

How can i do this?

[Jared12345]

Check out this video.

https://youtu.be/XP-gqeB9pFo 

[HoScho]

Thanks for the very good Video, but

index(
orderby(
[Name],
[DateTraining], true
),
1
)

return a Error "ORDERBY has invalid inputs"

[Jared12345]

I think you need to include the table that the Name column is in.

index(
orderby(
Table_name[Name],
[DateTraining], true
),
1
)

[HoScho]

I have now found the reason for the error.
orderby expects a KeyValue as the first argument.
But I can't set "Name" as a KeyValue. For me, this is the "Timestamp" column.
Any idea how I can solve this?

[Jared12345]

Hi. I think you can use the Sort() expression SORT() 

[Jared12345]

And wrap it in Unique. Unique(Sort())