Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello MFelix
Thanks a lot. Your code is working
Best regards
Simon
User | Count |
---|---|
94 | |
78 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |