design

Display # 5 10 15 20 25 30 50 100 All

Auto-generating SCHEMA.INI

Written by Teo Lachev on 20 January 2014.

Automate lookup table maintenance when using multiple Excel sources in a PowerPivot model

Written by Javier Guillen on 28 October 2012.

Automatically create data dictionary for your Power Pivot model

Written by Avichal Singh on 13 March 2014.

Basic date handling in DAX

Written by Cathy Dumas on 03 February 2012.

Blending "Time of Day" Analysis with Calendar/Date Analysis

Written by Rob Collie on 07 October 2014.

Bubbling Up Exceptions with "Sara Problem?"

Written by Rob Collie on 17 October 2013.

Bucketing Values in DAX

Written by Josh Caplan on 06 June 2014.

Budget Calculations That Change by Level

Written by Rob Collie on 21 November 2012.

Budget Patterns

Written by SQLBI on 15 May 2014.

Building a Flexible and Efficient Client-Side PowerPivot Solution in Excel 2013

Written by Dick Moffat on 14 August 2013.

Building Data Relationships in PowerPivot

Written by Artemakis Artemiou on 12 March 2010.

Building Relative Date Reports in PowerPivot

Written by Chris Webb on 24 January 2013.

Business Intelligence Prototyping with PowerPivot

Written by Javier Guillen on 28 April 2011.

CALCULATE ( ) Lessons from Looney Tunes

Written by Matt Allington on 05 September 2014.

Calculated Columns and Measures in DAX

Written by Marco Russo on 21 August 2015.

Calculated Fields vs Calculated Columns

Written by Scott Senkeresty on 05 December 2014.

Calculating "Same Store" Sales in PowerPivot

Written by Rob Collie on 21 August 2012.

Calculating First and Second Year of Sales by Customer in #dax #powerpivot #ssas #tabular

Written by Marco Russo on 12 September 2013.

Calculating Pearson Correlation Coefficient using DAX

Written by Gerhard Brueckl on 03 June 2015.

Calculating the Nth Best Performance (unique individuals) with Excel and PowerPivot

Written by David Hager on 22 June 2015.

• 1
• 2
• 3
• 4
• 5