Paste Serial Number From Row with Same Order Numbers

[mementocorgi]

I've got a large table of values (added a picture for clarity)

The problem I'm having is that while some of the SO's and SI's have the same Order Number, only the SO's have a serial number. What can I use to make a new column which copies the serial numbers from the SO's that have matching ON's to their corresponding SI rows? 

Any help is appreciated!

[AUaero]

Try this:

OrderSerialNumber = 
VAR ThisOrderNumber = SerialTest[OrderNumber]

RETURN
MINX(
    FILTER(
        SerialTest,
        SerialTest[OrderNumber] = ThisOrderNumber &&
        SerialTest[RecordSource] = "SO"
    ),
    SerialTest[SerialNumber]
)

[rsbin · Accepted solution]

@mementocorgi ,

There are different ways to accomplish this, but I believe this should work for you:

SerialNoRevised = 
VAR _Order = [OrderNo]
VAR _SerialNo = CALCULATE( MAX([SerialNo]), FILTER( SN, SN[OrderNo] = _Order && SN[Source] = "SO" ))

RETURN
    _SerialNo

OrderNoSourceSerialNoSerialNoRevised

1	SO	123	123
1	SI		123
2	SI		456
2	SO	456	456

In the future it would help to post sample data as a table, not an image.  This will help in facilitating answers to your posts.

Regards,

[mementocorgi]

Thank you! I'll do so next time.