THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DAX   (RSS)
Showing page 17 of 17 (163 total posts)
  • Memory Considerations about PowerPivot for Excel

    PowerPivot for Excel is an Add-In which uses a local version of Analysis Services (SSAS) to process data and make calculation to respond to user queries made using Excel 2010. The SSAS engine is loaded in-memory in the process of Excel. Especially with a 32 bit of Excel, there are particular considerations about the use of the memory. When an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 25, 2010
  • ABC Analysis in PowerPivot

    The calculation for ABC analysis can be made in PowerPivot using calculated columns. In this way each row can have an attribute with the appropriate ABC class. The ABC calculation has to be made considering a particular grouping and sort order. For example, we wanted to define an ABC class of Products for internet sales transactions of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 18, 2010
  • Distinct Count Measure in PowerPivot using DAX

    UPDATE: PowerPivot for Excel 2010 in SQL Server 2012 and Excel 2013 support the DISTINCTCOUNT aggregation in DAX. This blog post is relevant only if you use PowerPivot for Excel 2010 in SQL Server 2008 R2. A PivotTable based on PowerPivot data doesn’t offer a native Distinct Count aggregation. To calculate it, you need to create a calculated ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 26, 2009
Privacy Statement