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.  Incident Date 1 randomstring 1.1.2016 1 randomstring 2.1.2016 1 randomstring 5.1.2016 2 randomstring 3.1.2016...
  • 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])))

     

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

Thanks! This is exactly what I've been looking for. Do you know how I can make this a column instead of a measure? Like having a column with this value for all case numbers?