Forum Discussion

radu92's avatar
radu92
Icon for Helper I rankHelper I
9 years ago
Solved

Find the next higher value after MIN

Hi everyone, 

 

I have the following dataset: 

 

Case Nr. IncidentDate
1

randomstring

1.1.2016
1randomstring2.1.2016
1randomstring5.1.2016
2randomstring3.1.2016
2randomstring...
3randomstring...
4randomstring...
4randomstring...
4randomstring...

 

I would like to group this table by case nr., and choose the 2nd date after the earliest one. 

Any ideas how I can do this? 

 

Thanks in advance! 

  • Thiyags's avatar
    Thiyags
    9 years ago

    radu92

    Is this wat you are expecting.

    You can use the below formual

    2ndMinDate = CALCULATE(MIN(Sheet6[Date].[Date]), filter(Sheet6, Sheet6[Date].[Date]<>MIN(Sheet6[Date])))

     

3 Replies