I have a existing salesforce tables in my data model. I am having difficulty to set up proper relationships between sales rep, account, contact and task tables as the ambigirous relationship
The workaround is to break one of the link and replaces with a related column in the task tables. illustrate like below
Sales rep->Account->Contact (broken link), Task has contact column
My question is, without creating a new task table, how to enable the relationship column in existing task table? I just don't want to recreate 6 table and link up visual again, which could be two days works.
If in a new get source window, i click on the box.
The table i import has the relationship table.
So my question is how to enable them in an EXISTING tables, or any suggestion i can use DAX to create a new column?