need to display client classification based on latest date key

[vanir88]

Hi All,

i have a requirment link in filter if select master client it has to show the client classification valuse based on latest date key.
for example below is the data i have filters like , master client, client classification, master number,.....etc
now if i select value AAA based on latest datekey(29-08-2023) client classification has to display Diamond.

here one master client- one client classificatio means(1-1), how to achive this

datekey master client client classification master number contact Number

29-08-2023 AAA diamond 1000500653 876548984
25-08-2022 AAA Funded 1000500653 876548983
10-07-2023 AAA Diamond 1000500653 876548984
29-08-2023 AAA Diamond 1000500653 876548984

[BrunPierre]

Aggr(
Only({<DateKey = {"=DateKey=max(DateKey)"}>} [Client Classification]),
[Master Client]
)