OR Filters With Excel Cube Functions

Chris Webb shows how to build an OR filter in Power Pivot:

Now, imagine that you want a report with the Sales Amount measure on columns and Years on rows, and you want to filter the data so that you only see values for Mondays in July or Wednesdays in September. Using the Fields, Items and Sets functionality you could filter the data to only show the day/month combinations you need for each year, but since you can’t put a named set into the Filter area of a PivotTable you would have to use Excel formulas to sum up the combinations to get the totals you need

I’ve never used Excel’s Cube Functions.  Looks like something to add to the to-learn pile.

Related Posts

Roll Your Own SSAS Performance Monitoring Tool

Shabnam Watson has a great post on building an Analysis Services performance monitoring tool from scratch using Power BI: In many cases, SSAS works efficiently with default settings right out of the box. However, when you have large databases, substantial number of concurrent users, insufficient resources on your server, or when best practices are not […]

Read More

BI Announcements At PASS Summit

Chris Webb points out some good news released at PASS Summit: Power BI Report Server There’s a new release of Power BI Report Server available, and you can read all about it here: https://powerbi.microsoft.com/en-us/blog/new-version-of-power-bi-report-server-now-available/ The blog post highlights the fact that you can connect to SSRS shared datasets via OData – which is basically what […]

Read More


September 2016
« Aug Oct »