Return the value from the next matching row

[Anonymous]

Hello Team,

I have a table with different country - category and also frequencies. Currently I have just shown one below as an example. As we may have other country and category data and the order of the data might mismatch when we have all the country/category data.
So the "Month of data" Column refers to the data which is being validated in the current month.

For Eg: Region = IMEA, Country = India, Category = I
If "Month of Data" = January 18, then the data is being validated and is available on 27th Feb 2018(Expected Data of Input Column). But I wanted another result column where for the same filters Region = IMEA, Country = India, Category = I ,
I want the next date that is present in the Expected Data of Input Column and this will be 28th Mar 2018.

I want my results as seen in the "Output result" Column. 
Note: The order of all the columns changes accordingly, so please suggest a way to get this result keeping in account of Country, Category, and other related fileds.

A sample excel file data

 Kindly suggest a method of approach.

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try something on this pattern

Calculated column =
CALCULATE (
    MIN ( Table1[Date] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[Region], Table1[Country], Table1[Category] ),
        Table1[Date] > EARLIER ( [Table1[Date] )
    )
)

[Anonymous]

@Zubair_Muhammad Thank you for the solution. It worked 🙂