Forum Discussion

Rudyi's avatar
Rudyi
Helper I
6 years ago
Solved

Vlookup with powerquery from another source

Hi all, I'm quite new to power query and I'm trying to do I query out of my league.  I have one table with column of names Table1   Name AABC BBCD CCDE and second table with nami...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    New column in table 1

    new column = maxx(filter(table2,left(table1[Name],len(table2[naming]))=table2[naming]),Table2[value])

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

While on Table1, go to the Query Editor and split the column by position to extract the first 2 characters in another column.  Then merge this table with Table2 based on the new column created in Table1.  From Table2, bring over the value column to Table1.

Hope this helps.