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

     

    First of all Kudos to you for making a video on this !! You are amazing !!

     

    There may be some problem with the way I have modelled this data; so you are right when you find weird results in the visuals.

     

    None the less, the ways you have shown in this video will no doubt get me closer to what I want to acheve.

     

    Just a small question, if we didn't have summed the tasked in this video, would it show up correct numbers ? I will try it and let you know.

     

    Thanks heaps.

    • AJ007's avatar
      AJ007
      Helper I
      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.