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 and inventory table. How will i give

 

 

 

Need Help

4 Replies

  • 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.