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

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try this measure:

Measure = 
var a = IF(LEFT(MAX('Table 1'[Name]),LEN(MAX('Table 2'[naming]))) in FILTERS('Table 2'[naming]),LEFT(MAX('Table 1'[Name]),LEN(MAX('Table 2'[naming]))),0)
return
CALCULATE(SUM('Table 2'[value]),FILTER('Table 2','Table 2'[naming]=a))

The result shows:

Here is my test pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto Zhi