Kind of Vlookup

[Jay20024]

Hi Folks,

I'd like to import data from a table to another.

Got a table with components and related flavors

And another one with flavors and related points 

Using Dax, I'd like to import the points to a new column either in the first table, either in a new table merging both.

To get this :

I'd like to sum the number of point based on the components list.

Could you please help me ?

I thank you in advance.

[FreemanZ · Accepted solution]

hi @Jay20024 ,

there are multiple ways to do so, like addiing a calculated column in table1 with such code:

column = 
LOOKUPVALUE(    
    Table2[Point],
    Table2[Flavor],
    Table1[Flavor]
)

if the tables are connected, it can be even simpler. 

[Jay20024]

@FreemanZ, 

Easy indeed ! Many thanks for this. It works perfectly.