I’m using a SAP Data Set to analyse how many units have we receipted into the Warehouse v’s how many units we loaded to the Van Sales Order of the same line.
Did we load in full or suffer a loss?
My question is:
The delivery ID is SAP is an unique number, I would like to tie this same number into the empty column REF2 for all the TRAN Rows (Van Sales Loadings)
Basically creating a reference/relationship
How do I do that in Power Query?
I have heard of Fill Down option but I want the Unique Reference to repeat down the next column and then again for the next delivery of the next line and so on and so on.
Hope that makes sense
Any help would be greatly appreciated.