How to give RelationShip

[Naru]

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

[PowerBIGuy]

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]

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 · Accepted solution]

Try deleting all relationships and select autodetect.

[greggyb]

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