Hi,
I'm trying to retrieve in a KPI when the min or max value of my dataset occurs.
To put it simply I got 2 fields, one with times stamps and another with values. I want to retrieve the timestamp of the min/max value in a set expression.
I tried sum({<Value={$(=Max(Value))}>} [Date/Time]), it returns an absurd result,
I tried a simple if(Value=max(Value),[Date/Time]) and returns nothing.
Probably simple but I couldn't find any clue here yet and any help would be much welcome!
Etienne
