Set Analysis, select value linked to the latest date

[PavelKas]

Hi,

I have a table 

The Property depends on Date1 only, while Date1 is less or equal to Date.

I want to filter on Date and to get a Property value linked to the latest Date1 related to the selcted Date.

I.e.

Date            Property

01.01.2002    A

02.01.2002    B

03.01.2022    C

I think it is not so difficult if I select only one Date and {<Date1=Date>} may help. But it doesn't work if I select two or three Dates.

How can I solve this issue using Set Analysis if possible?

Thanks

[CELAMBARASAN]

Hi

Have you tried P()? Example as below

{<Date1=P(Date)>}

Regards

Celambarasan

[PavelKas]

Thank you Celambarasan! But I am afraid it doesnt work either

If I correctly understood your idea...

[hic]

It is not possible to use Set Analysis for conditions that require a row-level evaluation. And that is needed here.

But you can probably achieve ith through
Dimension=Date
Measure=Only(Aggr(FirstSortedValue(Property,-Date1),Date))

HIC

[PavelKas · Accepted solution]

Thank you Hic! You have goven me a direction!