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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.