Hello,
I'm having an issue looking for values from column in table 1 in a column in table 2. Tables are not related and a relationship cannot be created.
First I have created a column under table 1 called purchase order that retreive first last 9 caracters
Purchase Order = LEFT('Transport Orders'[PurchaseOrderNumbers],9)
Now, I need to search of the values found in column "purchase order" in the second tabl called "transport demand data[PurchaseOrderNumbers]"
I have tried lookupvalue, related but didn't work.
Please I need an urgent help!!
Thank you in advance!.
I'm having an issue looking for values from column in table 1 in a column in table 2. Tables are not related and a relationship cannot be created.
First I have created a column under table 1 called purchase order that retreive first last 9 caracters
Purchase Order = LEFT('Transport Orders'[PurchaseOrderNumbers],9)
Now, I need to search of the values found in column "purchase order" in the second tabl called "transport demand data[PurchaseOrderNumbers]"
I have tried lookupvalue, related but didn't work.
Please I need an urgent help!!
Thank you in advance!.