Apress Beginning Power BI with Excel 2013, Self-Service Business Intelligence Using Power Pivot Power View Power Query and Power Map (2014) by unknow

Author:unknow
Format: epub
Tags: Data Modeling & Design, Desktop Applications, Suites
ISBN: 9781430264453
Google: tm0pngEACAAJ
Amazon: 1430264454
Published: 0101-01-01T00:00:00+00:00

You can now add up the product quantity for products chosen. Add the following measure to the Inventory table. Product Quantity:=SUMX(

VALUES(Product[ProductKey]),[LNB Quantity])

The final step is to add up the inventory across all the stores selected using the following measure. Inventory Level:=SUMX(Values(Store[StoreKey]),[Product Quantity])

To test the measure, add a new sheet in Excel and create a pivot table like the one in Figure 6-21.

Figure 6-21. Testing the inventory measure

Summary

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.