Forum Discussion

AJ007's avatar
AJ007
Helper I
8 years ago
Solved

Table Relationship Doesn't Work

I have two tables. One with employee initials (e.g. AB, JS) and number of tasks they have done. I have another table with same employee initials and dates they worked on. I want to have a single visu...
Need Help
  • AJ007's avatar
    AJ007
    8 years ago

    Sum or otherwise, it still didn't work and it wouldn't even take me to the level you managed to get to.

     

    I think there is something wrong with this version of Power BI. I was using the latest January 2018 update.

     

    I will redownload and install. Thanks.

  • AJ007's avatar
    AJ007
    8 years ago

    Actually what I did is I added a new column called ID in both Excel files. Power BI then automatically established a 1 to 1 relationship in both direction and I was able to get the single visual I wanted.

     

    I don't know the consequences of doing this in a larger and actual dataset but it worked for what I wanted to achieve in this test.

     

    Thanks.

AJ007's avatar
AJ007
Helper I
8 years ago

Actually what I did is I added a new column called ID in both Excel files. Power BI then automatically established a 1 to 1 relationship in both direction and I was able to get the single visual I wanted.

 

I don't know the consequences of doing this in a larger and actual dataset but it worked for what I wanted to achieve in this test.

 

Thanks.