Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
powerinM
Helper II
Helper II

Lookvalue DAX

Lookupvaluedax.JPGHi : 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

 

 
 

 

1 ACCEPTED SOLUTION
smpa01
Super User
Super User

@powerinMLOOKUPVALUE does not work as a meaure unless it is wrapped inside a table function

e.g.

Capture.PNG

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

View solution in original post

2 REPLIES 2
smpa01
Super User
Super User

@powerinMLOOKUPVALUE does not work as a meaure unless it is wrapped inside a table function

e.g.

Capture.PNG

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Thanks for your prompt response and it make sense.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.