Forum Discussion
Lookupvalue in different table add data to new column
I am trying to create something similar to a Vlookup /transpose in excel and I can’t get it to work in Powerbi. please can anyone help me. I am trying to lookup data in table 2 to go into table 1,...
Hi Anonymous ,
Please try below steps:
1. below is my test steps:
Table1:
Table2:
No relationship between both table:
2. add a new column with below dax formual in Table1
Column =
VAR _a =
LOOKUPVALUE ( Table2[Column2], Table2[Column1], Table1[Column1] )
VAR len_a =
LEN ( _a )
RETURN
MID ( _a, 6, len_a )
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
123344tk, printer, phone
A lot of the instances have multiple items, I am trying to transpose the rows into seperate collumns, eg 12244TK has printer and phone. I have seperate collums for each item, printer, phone, scannner etc...