Forum Discussion
Will Power Pivot be enough?
Hello everyone, I am about to build a data-model, but I am unsure whether I will be able to build it in Excel (Power Pivot) since the filtering direction can only be set to one direction. In cont...
Hi Rajesh!
As of now, I do not have an example, it is more of a general question. I am just wondering if the uni-directional relationships will become a problem since you cannot set the relationship to bi-directional in Excel 🙂
As of now, I do not have an example, it is more of a general question. I am just wondering if the uni-directional relationships will become a problem since you cannot set the relationship to bi-directional in Excel 🙂
Let me say something about the basic of relationship between Tables.
- One to One:
- One to Many:
- Many to Many:
1. When both parent & child table has one common column setting the relationship. and no duplicate records, like ID in both tables, has Unique records.
2. When parent table has unique records ( like unique IDs) but child table has duplicate.
3. Many to Many works when both tables has duplicates for the Field ( IDs )setting relation between tables.
Using Data model,,, data diagram you can set relationship between tables.