lookupvalue does not find data that does exist

[Syndicate_Admin]

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

[amitchandak]

@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

[Syndicate_Admin]

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