Forum Discussion
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. 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!
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 _SerialNoOrderNoSourceSerialNoSerialNoRevised
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,
3 Replies
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 _SerialNoOrderNoSourceSerialNoSerialNoRevised
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,
Thank you! I'll do so next time.
Try this:
OrderSerialNumber = VAR ThisOrderNumber = SerialTest[OrderNumber] RETURN MINX( FILTER( SerialTest, SerialTest[OrderNumber] = ThisOrderNumber && SerialTest[RecordSource] = "SO" ), SerialTest[SerialNumber] )
