Forum Discussion
Solved
Linking Two Tables with Multiple Entries
As I understand this is a relationship problem, but I am unsure how to properly link these items to get it to function correctly. Both tables have many projects each having their own set of acti...
Solutions did not work as desired, in the end power query ammending the tables got a result that worked.
Hi LiNSiCKeL,
On the model page, make sure you have a unique value on a table.
You have a single line for each activity on table 1 and link to field "Activity" of the table.
The relation between will be 1-to-many(*) and it should work !
One way to optimize that is to have a dimension table of unique value of Activity and a fact table that contains all records.
Hope it can help you!
Best regards,
Antoine