Forum Discussion
Newbie Data Lookup
This is the foundation of Power BI. You need to join the 2 tables with a relationship in the relationship view. The rest will just work, as long as that column in the first table is unique (as you suggest).
You may like to read my article about Relationships In Power BI.
You are not allowed blanks in the table on the 1 side of the relationship. Remove the blanks with Power Query first.
Hi Anonymous,
In Query Editor mode, select the [Code] field in Table1, then, remove empty and remove duplicates.
Then, in data view mode, add a calculated column in Table2 with LOOKUPVALUE function.
New Column = LOOKUPVALUE ( Table1[Desc], Table1[Code], Table2[Code] )
Best regards,
Yuliana Gu
This is the foundation of Power BI. You need to join the 2 tables with a relationship in the relationship view. The rest will just work, as long as that column in the first table is unique (as you suggest).
You may like to read my article about Relationships In Power BI.
Hi Matt,
Thank you for your response, I double checked that the master table doesnt contain duplicates on the 1st row, but yet I still get the error message about one tables column must contain unique values. I see on the one table the data is blank but is visible why I click the drop down on the filter?
Any ideas?
You are not allowed blanks in the table on the 1 side of the relationship. Remove the blanks with Power Query first.
Hello Matt,
I double checked that there is no blanks in the first table and yet the relationship cannot be established.
Please help