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])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

New column in table 1

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

Rudyi's avatar
Rudyi
Icon for Helper I rankHelper I
6 years ago

Hi ,

amitchandak is it possible to do the same on the query level somehow? Same function gives me an error in query editor 😞

v-gizhi-msft thanks, your solution works as well!

 

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,

     

    If my answer has solved your solution, please mark it as a solution for others to see.

    Thanks!

     

    Best Regards,

    Giotto Zhi