Forum Discussion
Pivot Table Relationships and Multiple Responses
Hi, I'm new to Pivot Tables and relationships and while this feels like a basic question, I can't find a suitable example anywhere so hoping someone can help. I have three tables with relationshi...
Yes, in general physical relationships are better. However,
- many-to-many (bi-directional) is not supported natively in Excel. As workaround here may generate measure with CROSSFILTER which imitates such behaviour
- in general bi-directional is not recommended, that could be negative side effects with it. If you can avoid it - better to avoid.
The only limitation could be performance. In most practical cases for Excel TREATAS works fine. If you don't have dozen millions of rows in the model we usually speak about milliseconds.
SergeiBaklan thank you so much, this has really helped me out
NeilMcLeod , you are welcome
