Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this?
= FirstsortedValue( Date(begindate), Aggr(Min(Close), begindate, Close))
Which object we need to look?
Where did you use this expression? Or you want to create a new textbox with this expression? What should be your expected output. ?
In text object write
=Only({<begindate = {"$(=Min({<Close = {'*'}>}[begindate]))"}>} begindate)
Maybe like attached with two new text objects.
May be try this?
= FirstsortedValue( Date(begindate), Aggr(Min(Close), begindate, Close))
Changing the Min to Max will give the Max Date?
Yes, like use - minus to aggr.
= FirstsortedValue( Date(begindate), -Aggr(Max(Close), begindate, Close))
Dear Joe but what about your condition that you suggest in your question this is not in your expression.
= Min({<Close = {"$(=Min({<Close = {'*'}>}))"}>} begindate)
My expression is wrong..
I need to get the date where the min value of the measure occurred.