Date when a min value occurred

[sqlpuzzle]

I need to find the date on which the Minimum value of a measure happened.

= Min({<Close = {"$(=Min({<Close = {'*'}>}))"}>} begindate)

But not working sample attaced.

[Anil_Babu_Samineni]

Which object we need to look?

[vishsaggi]

Where did you use this expression? Or you want to create a new textbox with this expression? What should be your expected output. ?

[its_anandrjs]

In text object write

=Only({<begindate =  {"$(=Min({<Close = {'*'}>}[begindate]))"}>} begindate)

[its_anandrjs]

Maybe like attached with two new text objects.

[vishsaggi · Accepted solution]

May be try this?

= FirstsortedValue( Date(begindate), Aggr(Min(Close), begindate, Close))

[sqlpuzzle]

Changing the Min to Max will give the Max Date?

[vishsaggi]

Yes, like use - minus to aggr.

= FirstsortedValue( Date(begindate), -Aggr(Max(Close), begindate, Close))

[its_anandrjs]

Dear Joe but what about your condition that you suggest in your question this is not in your expression.

= Min({<Close = {"$(=Min({<Close = {'*'}>}))"}>} begindate)

[sqlpuzzle]

My expression is wrong..

I need to get the date where the min value of the measure occurred.