Help! - How to lookup the second value of a date column in ascending order using a measure?

[Anonymous]

I have a date column.

I need to lookup the second value of the column and use that in a if condition.

Can I do this without ranking the column?

Any help would be appreciated,.

[v-yuta-msft]

@Anonymous ,

Could you share some sample data and give the expected result?

Regards,

Jimmy Tao

[Anonymous]

I have two columns:

Start Date            End Date

      a                                a1

      b                                b1

      c                                c1

      d                                d1

My condition is to compare the two columns as follows:

if ( b>a1)

Yes - I should increment the no of comparisions - if (c>a1) & if (c>b1) and goes on if Yes again......

No - another condition.

Any help would be appreciated.

Thanks,
Anand