topic Re: Vlookup in DAX Commands and Tips

Vlookup

Anonymous — Fri, 09 Feb 2024 09:51:08 GMT

I want to feed the column 'TABLE 01'[ID] with ID contained from table 02

to get this

How can I do it in DAX please. I thank you in advance.

Jay

ValtteriN — Fri, 09 Feb 2024 10:37:47 GMT

Hi,

You don't really even need dax. If you have these two tables:

Just create a relationship like this:

Now you can visualize the account from one table and get the corresponding id:

If you want to use dax:

Column:
(RELATED is the most straigt-forward)

If you don't have a relationship:

Id =

var _acc = [Account] RETURN

CALCULATE(MAX('Table (24)'[Id]),'Table (24)'[Account]=_acc)

Measure:

Id_m =

var _acc = MAX('Table (25)'[Account]) RETURN

CALCULATE(MAX('Table (24)'[Id]),'Table (24)'[Account]=_acc)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/