Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Vlookup

Hi    I want to feed the column 'TABLE 01'[ID] with ID contained from table 02                                       to get this                         ...
  • ValtteriN's avatar
    ValtteriN
    2 years ago

    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/

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
2 years ago

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/