topic Re: Kind of Vlookup in DAX Commands and Tips

Kind of Vlookup

Jay20024 — Wed, 23 Oct 2024 08:34:16 GMT

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 — Wed, 23 Oct 2024 08:56:24 GMT

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 — Wed, 23 Oct 2024 13:53:51 GMT

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