design

Display # 5 10 15 20 25 30 50 100 All

Calendar Reporting with Excel and Power Pivot

Written by Josh Caplan on 25 June 2014.

Campaign Analysis: Seasonally-Adjusted Measures

Written by Rob Collie on 19 January 2011.

Can EARLIER be used in DAX measures?

Written by Javier Guillen on 06 February 2012.

Changing PivotTable Names in Excel 2013 + Bug Alert

Written by Jason Thomas on 26 November 2012.

Charts that are dynamically "indexed" to first value

Written by Rob Collie on 08 October 2013.

Choosing Numeric Data Types in DAX

Written by Vidas Matelis on 12 May 2016.

Classifying and Solving the Events in Progress Problem in PowerPivot

Written by Jason Thomas on 28 November 2012.

Clever Hierarchy Handling in DAX

Written by Alberto Ferrari on 30 April 2012.

Combine two files (or fact tables) in PowerPivot using relationships, relationships explained

Written by Kasper de Jonge on 11 April 2010.

Commission Calculations in PowerPivot

Written by David Churchward on 13 May 2012.

Comparing Any Two Time Periods in DAX

Written by webadmin on 20 June 2012.

Configurable Running Totals in PowerPivot

Written by Jason Thomas on 02 October 2012.

Consolidation and Intercompany Elimination made easy using PowerPivot and DAX

Written by Gerhard Brueckl on 21 May 2012.

Consolidation and Intercompany Elimination with parallel hierarchies

Written by Gerhard Brueckl on 31 May 2012.

Controlling the Position of Subtotals in DAX with GenerateAll()

Written by Chris Webb on 16 May 2012.

Correlating "Fuzzy Time" Events in One Table with Precise Measurements in Another Table

Written by Rob Collie on 28 February 2012.

Costs of Relationships in DAX

Written by Marco Russo on 06 August 2015.

Counting "Active" Rows in a Time Period

Written by Chris Campbell on 10 April 2013.

Counting Things that Didn't Happen

Written by Rob Collie on 08 August 2013.

Create a dynamic table from powerpivot data in Excel 2013 without vba

Written by Erik Svensen on 24 February 2013.

• 1
• 2
• 3
• 4
• 5
• 6