Forum Discussion

Naru's avatar
Naru
Icon for Advocate I rankAdvocate 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.

Naru's avatar
Naru
Icon for Advocate I rankAdvocate 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
Icon for Responsive Resident rankResponsive Resident
10 years ago

Try deleting all relationships and select autodetect.

  • greggyb's avatar
    greggyb
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

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