Forum Discussion
Linking to a single name table from 4 different tables
Hi Yuliana, thanks for the post.
Correct, I was hoping to somehow create a link table in PowerBI and then use that within a larger spend analysis query. The spend data attached to each table record of a vendor would then carry through to the vendor record in the link table, irrespective as to the financial system from which it originated.
The only relationship between names is text. I am unable to obtain a DUNS, Tax or company record number for the entities to act as a unique key.
Microsoft EmployeeHi Phyxius,
The "Vendor Link Table" is your desired result which should be generated in Power BI right? Is there any relationship about vendor names in these 4 tables? Apart from these 4 financial tables, is there any other source that can determine the mapping relationship of vendor names? If all these tables are completely separate, there is no way to achieve above requirement in Power BI. You have to generate the Link table in your source data to list all mapping relationships.
Regards,
Yuliana Gu
Hi Yuliana, thanks for the post.
Correct, I was hoping to somehow create a link table in PowerBI and then use that within a larger spend analysis query. The spend data attached to each table record of a vendor would then carry through to the vendor record in the link table, irrespective as to the financial system from which it originated.
The only relationship between names is text. I am unable to obtain a DUNS, Tax or company record number for the entities to act as a unique key.