Forum Discussion
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. ...
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,
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.