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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Syndicate_Admin
Administrator
Administrator

lookupvalue does not find data that does exist

Good afternoon

I have the following problem, I have 2 tables relationship 1 is to several I need to bring bus prices data from different sku to the master promotions table with some data the lookup works and with others returns whites being that the data if it exists.

I have tried related, maxx, filter, etc and nothing. I hope you can help me

data

3 REPLIES 3
amitchandak
Super User
Super User

@Syndicate_Admin , The file format is not correct.

 

You need use 1 of the 4 ways

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Friend I tried many ways so I ask for help, try filter, calculate, maxx combined and nothing brings me whites, I must bring to the table promotions master the bg of the sku that is in bus prices with some works and others brings whites. Obviously there are some that do not exist in bus prices but the rest there is no case please help!!!!

Fix the pbix file. 😀

Hello!!

I have the same problem. How did he solve it?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors