Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Find second Min value

Hi have a table like below

I need to find the Min value for each day. however, all days have 0 in it and min(latency) will give 0 for all day.

But i want to show the next min value. For example : 32 for 13-04-20 & 5 for 14-04-20.

Please help me how i can achieve this.

parry2k
6 years ago
Anonymous try this measure

Min Value = CALCULATE ( MIN ( Table[Latency] ), ALLEXCEPT ( Table, Table[Date] ), Table[Latency] > 0 )

I would 💖 Kudos 🙂 if my solution helped. ?

3 Replies

parry2k
Super User
6 years ago
Anonymous try this measure

Min Value = CALCULATE ( MIN ( Table[Latency] ), ALLEXCEPT ( Table, Table[Date] ), Table[Latency] > 0 )

I would 💖 Kudos 🙂 if my solution helped. ?
- Anonymous
  Not applicable
  6 years ago
  I figured that the below also works
  2ndMinDate =
  CALCULATE(MIN(table[Latency]),
  filter('table','table'[Latency]<>MIN('table'[Latency])))
  - parry2k
    Super User
    6 years ago
    Anonymous you want to avoid using FiLTER function as it can be very expensive on larger datasets. Cheers!