Forum Discussion
Two Associations to the Same Table
I have two associations to a "user" table for two different columns in a "project" table. I am told I need to have a different instance of "user" in order to join to a different column in the "proje...
I have a dashboard showing all users who create projects in a ticketing system, however, not all users create their own projects. I have a dashboard to show the time spent by all users on projects (modified by). So I have two scenarios and need two relationships (created by and modified by) but both need to point to the same "user" table. To achieve this, can I use PowerBI to duplicate the user table (user2), so I can then have both scenarios to create both dashboards? What is the best way to achieve this, and how can I keep table 2 updated with table 1.