O'Reilly logo

PowerPivot for Business Intelligence Using Excel and SharePoint by Barry Ralston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculated Measures from Multiple Data Sources

Another reason to employ a DAX calculation is in the creation of a new measure from multiple data sources. From the example download, Chatper04\DAX Measures.xlsx is a sample workbook containing a trivial amount of data from a fictional Internet retailer. The workbook contains data for both product sales (SalesFacts) and page views from the company web site (PageViewFacts).

The Business Problem

While the example workbook contains data for both sales and web activity, as is often the case in real work, both datasets are needed for the calculation of a value not stored in either source. For example, one of the management team for a fictitious web retailer believes understanding how many page views occur ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required