Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |