Get value of next incidence of pallet with specific operation

[Gresi]

Hi everybody,

i'm really new to Power Bi.

I've a table with different entries of pallets.

The pallets arrive at stations and leave stations.

For example:

Pallet 006 arrived at station on 01.07.2019 15:46:24,

it leaves the station same day at 15:57:58.

How could i achieve that the end-value of the rows with operation ArrivedAtStation becomes the start-value of the next row where the pallet has left the station.

It would be nice if someone could help me.

thx, Gresi

[Zubair_Muhammad · Accepted solution]

@Gresi 

Try this as calc column

End =
MINX (
    TOPN (
        1,
        FILTER (
            YourTableName,
            [pallet] = EARLIER ( [pallet] )
                && [start] > EARLIER ( [start] )
        ),
        [start], ASC
    ),
    [Start]
)

[Gresi]

Hi,

thanks for the fast answer !

I've solved it already.

thx, Gresi