Calculated Column Get next Value per Group in same Table

Hi joshua1990

NextInfo =
VAR nextStep_ =
    CALCULATE (
        MIN ( Table1[Step] ),
        Table1[Step] > EARLIER ( Table1[Step] ),
        ALLEXCEPT ( Table1, Table1[Article] )
    )
RETURN
    IF (
        ISBLANK ( nextStep_ ),
        Table1[Info],
        CALCULATE (
            DISTINCT ( Table1[Info] ),
            Table1[Step] = nextStep_,
            ALLEXCEPT ( Table1, Table1[Article] )
        )
    )

AlB : Thanks a lot! It is not working:

"A table of multiple values was supplied where a single value was expected.".

I guess we need also the article r as a filter since since the steps are different between the articles. 

joshua1990 

It already has the filter on the article: through context transition and the ALLEXCEPT().

It does work in the data you have provided. See the attached file.

If you get that error it means that your data has more than one value in the column Info for the same article-Step combination. You'd need to review your data or decide what to do in those cases: which Info value do you keep? If for instance you want to keep the first one alphabetically, it suffices with using MIN instead of the DISTINCT on the code    

NextInfo =
VAR nextStep_ =
    CALCULATE (
        MIN ( Table1[Step] ),
        Table1[Step] > EARLIER ( Table1[Step] ),
        ALLEXCEPT ( Table1, Table1[Article] )
    )
RETURN
    IF (
        ISBLANK ( nextStep_ ),
        Table1[Info],
        CALCULATE (
            MIN ( Table1[Info] ),
            Table1[Step] = nextStep_,
            ALLEXCEPT ( Table1, Table1[Article] )
        )
    )