Forum Discussion

Valnus's avatar
Valnus
Helper II
4 years ago
Solved

Table Relationships

I have two tables    1) Dataset 2) Date Table  There is no relationship between the two that Power Bi can pickup. I can link Assessment Dates column to the corresponding Date table month for a ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi Valnus 

     

    If the sole purpose of creating index columns in both tables so that you can create a relationship betwen them (link the tables) then you don't need to do that.  PBI should, and by the looks of it has, identified the relationship and created it.

     

    You can now create visuals/reports/measures based off the 2 tables by the relationship that exists between them.

     

    Regards

     

    Phil

Valnus's avatar
Valnus
Helper II
4 years ago

Thanks 

 

I wanted to create two index colums in each table to create the link as I did not see the date link between the two tables and I created it by dumb luck.

Maybe my understanding of this in Bi needs a correction. 

But is the idea of a duel index columns a bad one ? 

 



PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi Valnus 

 

If the sole purpose of creating index columns in both tables so that you can create a relationship betwen them (link the tables) then you don't need to do that.  PBI should, and by the looks of it has, identified the relationship and created it.

 

You can now create visuals/reports/measures based off the 2 tables by the relationship that exists between them.

 

Regards

 

Phil