Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |