Forum Discussion

SimonWeber's avatar
SimonWeber
Frequent Visitor
9 years ago
Solved

Dax VLOOKUP same Table or any suggestion

Hello I’m new here and of course I have a question to power BI especially to Dax.   I want to make a VLOOKUP (excel expression) within the same table. With Excel I would make it like this: ...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi SimonWeber,

     

    I have a made a simple table with the 3 values you need tey to add a column with the following code:

     

    Column = IF (
              Table1[ID] = 901,
              LOOKUPVALUE ( Table1[Vonplatz], Table1[Nachplatz], Table1[Vonplatz] ),
              Table1[Vonplatz]
              )

    You should get the desired result if you want you can make the 901 a variable on your model.

     

     

    Regards,

    MFelix

     

     

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi SimonWeber,

 

I have a made a simple table with the 3 values you need tey to add a column with the following code:

 

Column = IF (
          Table1[ID] = 901,
          LOOKUPVALUE ( Table1[Vonplatz], Table1[Nachplatz], Table1[Vonplatz] ),
          Table1[Vonplatz]
          )

You should get the desired result if you want you can make the 901 a variable on your model.

 

 

Regards,

MFelix

 

 

 

 

SimonWeber's avatar
SimonWeber
Frequent Visitor
9 years ago

Hello MFelix

 

Thanks a lot. Your code is working :smileyhappy:

 

Best regards

Simon