how to create a link table in Power BI?

[Anonymous]

I'm slightly confused how to create a link table in Power BI. is there any related videos' available? Please share.

Thank you!

[HarishKM]

@Anonymous  Hey,
You can create a reference table in power query or you can use a key or ID for creating an relationship .

if you wanted to create more one relationship then use This link

[v-cazheng-msft · Accepted solution]

Hi @Anonymous 

Do you want to create relationships between your tables in the model? If so, you can refer this video Understanding relationships in Power BI Desktop and this official document Model relationships in Power BI.

If you want to create a table to link two fact tables, you can try the following solutions.

1 You can manually create a link table with the common fields of the original tables by the option Enter data. Then create relationships from these tables.

2 You can also consider Calculated table and then create relationships. For how to create Calculated table, you can refer Create subsets of your data with calculated tables and  create Calculated tables in Power BI Desktop.

If I misunderstand your needs or you still have question, please let me known.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!