How to link SOURCE field for sales and AR Table ?

[Paulyeo11]

Hi All

In order to make 2 Table share the SOURCE field :-

My PBI file

https://www.dropbox.com/s/ldl46wqg37ydbpj/PB_TDS_V060%20ASK%20LINK%20SOURCE%20FOR%20SALES%20N%20AR.p...

Paul Yeo

[v-xuding-msft]

Hi @Paulyeo11 ,

It does not make sense to create an active direct table relationship between the Sales table and the AR table.

I believe your current table model can support you to complete the business logic you want.

If you really want to create such a table relationship, you can create an inactive relationship and then use USERELATIONSHIP function (DAX) - DAX | Microsoft Docs  function.

[Paulyeo11 · Accepted solution]

Hi Xuding

thank you for your sharing

Amit have help me solve the issue.

https://community.powerbi.com/t5/Desktop/Case-062-How-to-link-target-and-sales-with-source/td-p/1509...

[PhilipTreacy]

Hi @Paulyeo11 

If you want to create a relationship between the two tables you click on Source in one table then drag your mouse over to Source in the other table.

But, I imagine that there would be a many to many relationship with those tables so really you should have a separate table with your Sources and then link that to both Sales and AR.

Cheers

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.