Dax VLOOKUP same Table or any suggestion

[SimonWeber]

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:

I tried it with a VLOOKUP in Power BI but this does not work. What is he right way to do this in DAX?

I am grateful for any suggestion.

[MFelix · Accepted solution]

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]

Hello MFelix

Thanks a lot. Your code is working

Best regards

Simon