Forum Discussion

Naru's avatar
Naru
Advocate I
10 years ago
Solved

How to give RelationShip

Hi All,   I have total 4 tables Store(Storeid,StoreName),MonthTable(Month),Sales(Storeid,Month,Sales),Inventory(Storeid,Month,Qty). Now i want to give active relation store,month tables to sales an...
Need Help
  • PowerBIGuy's avatar
    PowerBIGuy
    10 years ago

    Try deleting all relationships and select autodetect.

PowerBIGuy's avatar
PowerBIGuy
Responsive Resident
10 years ago

If you goto Manage relationships the following relationships should be active.

 

 

From:Table(column)                          To:Table(Column)
sales(Storeid)                                      Store(Storeid)
sales(Month)                                       Month(Month)
inventory(Storeid)                               Store(Storeid)
inventory(Month)                                  Month(Month)

Naru's avatar
Naru
Advocate I
10 years ago

Hi already i have tried same way  , but it saying  "Threre's alreay an active relationship between these two tables.You can deactivate relationship ,and make them as active " .

  • PowerBIGuy's avatar
    PowerBIGuy
    Responsive Resident
    10 years ago

    Try deleting all relationships and select autodetect.

    • greggyb's avatar
      greggyb
      Resident Rockstar
      10 years ago

      Mark your relationships to be one-way not bi-directional.