Forum Discussion
Vlookup
Hi
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
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] RETURNCALCULATE(MAX('Table (24)'[Id]),'Table (24)'[Account]=_acc)Measure:
Id_m =var _acc = MAX('Table (25)'[Account]) RETURNCALCULATE(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/
1 Reply
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] RETURNCALCULATE(MAX('Table (24)'[Id]),'Table (24)'[Account]=_acc)Measure:
Id_m =var _acc = MAX('Table (25)'[Account]) RETURNCALCULATE(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/