design

Display # 5 10 15 20 25 30 50 100 All

PowerPivot Time Calculations

Written by Teo Lachev on 18 January 2011.

PowerPivot Tips and Tricks - First Findings

Written by webadmin on 22 November 2010.

PowerPivot Top N Reports Using Excel Cube Formulas

Written by Chris Webb on 15 July 2012.

PowerPivot V2 CTP3!

Written by Rob Collie on 12 July 2011.

PowerPivot, Parent/Child and Unary Operators

Written by Alberto Ferrari on 01 March 2011.

PowerPivot's Filter Context from a SQL perspective

Written by Vincent Baldwin on 15 August 2012.

PowerPoint and Excel: Perfect Partners for Dynamic Tables and Dashboards

Written by Glenna Shaw on 08 April 2014.

Prepayments and Deferred Revenue

Written by David Churchward on 24 January 2012.

Profiling data in PowerPivot: comparing two tables

Written by Javier Guillen on 05 November 2012.

Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel

Written by Microsoft on 15 May 2013.

Quartile, Percentile and Median in PowerPivot

Written by Javier Guillen on 12 July 2011.

Recursive Calculations in PowerPivot using DAX

Written by Gerhard Brueckl on 23 April 2015.

Related Distinct Count

Written by SQLBI on 24 February 2014.

Resolving Many to Many relationships leveraging DAX Cross Table Filtering

Written by Gerhard Brueckl on 13 May 2012.

Restructure Your Data Table for Improved Compression

Written by Vidas Matelis on 08 January 2016.

Returning the First Temperature in PowerPivot

Written by David Hager on 22 June 2015.

Reverse Polarity RELATED()

Written by Ken Puls on 08 October 2013.

Running Totals Without a Traditional Calendar Table

Written by Rob Collie on 05 July 2011.

Same Store Sales Continued - Using Store Open/Close Dates

Written by Rob Collie on 23 August 2012.

SCOPING at different granularities (Part III)

Written by Javier Guillen on 21 May 2012.

• 8
• 9
• 10
• 11
• 12
• 13
• 14