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...
Many-to-many still is not supported in PowerPivot. But that shall not be a showstopper, proper designed bridge tables and measures allow to receive desired result. There are a lot of posts related to M2M in Power Pivot, first what google shows
Many-to-Many relationships in PowerPivot - SQLBI
A mystifying and awesome solution for many 2 many | P3 Adaptive
By the way, above two resources, sqlbi.com and p3adaptive.com (former powerpivotpro.com) are quite useful, on them you may find answer practically on any related to DAX question.