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.
Hi : I am trying to get my head around the lookvalue dax function. I am going through some materials (Lookupvalue Introduction) posted in SQLBI website. When I typed in the same exact syntax (as shown above) I get an error. In the "Search value" part of the syntax when I type Sales[ProductKey] formula engine is not recognising this column reference. I can't even see that column in the intellisense so I just type it in. The exact syntax in the sample file is working fine and no error. I am not sure what exactly going wrong here.
Correct me if I am wrong, I am creating this measure from the sales table asking to return Unit Price form the Product table using ProductKey in the sales table via corresponding the ProductKey in the Product table. Any help would be greatly appreciated.
Many Thanks
Solved! Go to Solution.
@powerinMLOOKUPVALUE does not work as a meaure unless it is wrapped inside a table function
e.g.
@powerinMLOOKUPVALUE does not work as a meaure unless it is wrapped inside a table function
e.g.
Thanks for your prompt response and it make sense.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |