Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
61
Views
Topic starter
Hi
In the tutorial on ALLEXCEPT (9.07) at the end you say that if you add new columns to your table then they will automatically be unfiltered. I was wondering do you mean both the pivot table and the products table in the PP model. I believe you mean both but would appreciate it if you could confirm that, Also if that is the case can you give me an example of a scenario where you would want to do that?
Thanks
Posted : 17/06/2019 4:15 pm
Hi Deborah,
Both. The idea of ALLEXCEPT is that it allows your model to grow without you having to maintain filters for new columns/fields added. It's an alternative to using ALL so the idea behind it is the same, however there are several examples of it in use here.
Mynda
Posted : 18/06/2019 1:30 am
