Previous ID in table

Hi frankhofmans ,

You can try calculated column like below:

Previous_Order_ID = 
VAR CurrentOrderDate = 'YourTableName'[Order_date]
VAR CurrentClientID = 'YourTableName'[Client_ID]
VAR CurrentOrderID = 'YourTableName'[Order_ID]
VAR a =
    CALCULATE (
        MAX ( 'YourTableName'[Order_ID] ),
        FILTER (
            'YourTableName',
            'YourTableName'[Client_ID] = CurrentClientID
                && 'YourTableName'[Order_date] < CurrentOrderDate
        )
    )
VAR table_ =
    FILTER (
        ALL ( 'YourTableName' ),
        'YourTableName'[Client_ID] = CurrentClientID
            && 'YourTableName'[Order_date] = CurrentOrderDate
            && 'YourTableName'[Order_ID] < CurrentOrderID
    )
VAR b =
    CALCULATE ( MAX ( 'YourTableName'[Order_ID] ), table_ )
RETURN
    IF ( COUNTROWS ( table_ ) > 0, b, a )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.