Forum Discussion

mementocorgi's avatar
mementocorgi
Frequent Visitor
3 years ago
Solved

Paste Serial Number From Row with Same Order Numbers

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. ...
Need Help
Tips and Tricks
Tutorial Requests
  • rsbin's avatar
    rsbin
    3 years ago

    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,

AUaero's avatar
AUaero
Responsive Resident
3 years ago

Try this:

OrderSerialNumber = 
VAR ThisOrderNumber = SerialTest[OrderNumber]

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