Reputation: 21764
It is possible to create context aware measures in Power Pivot. This is very powerful.
If I want to create reports in Excel based on an Access database, can I use something similar to measures from Access or do I need to go via Power Pivot to get that functionality?
Upvotes: 0
Views: 42
Reputation: 2229
Best bet is to use Power Pivot measures. You'll need to load the data from the Access database into excel anyways, so just build the measures in Power Pivot.
Upvotes: 1