Forum Discussion

Rudyi's avatar
Rudyi
Icon for Helper I rankHelper 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])