LOOKUPVALUE in Power BI not working

[YingFa]

I am using Lookupvalue in Power BI from two different excel files loaded to Power BI. In one excel file called "data", I have the column "customer name" of different product names and a column "Product name". In another excel called "Main Database" I have the column "product name" filled with the name of the products. This name can be repeated several times along the way. When I create a new column and apply the below formula, the value in the new column gives me the customer name for those products but it gives me blank for some of others, even when the "data" file includes these product names. Can I please have your help on this to know what I am doing wrong?

Customer Name = (LOOKUPVALUE(data[CUSTOMER_NAME],data[PRODUCT_NAME],'Main Databse'[PRODUCT NAME]))

Thank you,

 

[Matt Allington]

If you are using LOOKUPVALUE, then you are probably going about it the wrong way. There is a lot to learn, but I share a lot of info on my blog. I suggest you start here

The Optimal Shape for Power BI Data

It is common for self taught Power Pivot users to get the shape of their data all wrong. This article describes the optimal way to do it.

exceleratorbi.com.au

Relationships in Power BI and Power Pivot

Level: Beginners Power Pivot is a database that has been designed from the ground up to be optimised for reporting and analysis in Power BI, Power Pivot for Excel and SSAS Tabular. The technology is essentially the same across all of these products so I will generically refer to Power [...]Read...

exceleratorbi.com.au

generally you would use relationships to join tables. LOOKUPVALUE is an uncommon way to bring data from one table into another, which generally defeats the purpose of power BI.