design

Display # 5 10 15 20 25 30 50 100 All

End of Excel VLOOKUPS – Power Pivot Relationships

Written by Vidas Matelis on 21 March 2016.

Events-In-Progress for Time Periods in DAX

Written by Gerhard Brueckl on 30 December 2014.

Excel 2013 - Implications for PowerPivot and Excel Data Import Users-Part I

Written by Colin Banfield on 24 September 2012.

Excel 2013 - Implications for PowerPivot and Excel Data Import Users-Part II

Written by Colin Banfield on 26 September 2012.

Excel 2013, Power View, top 10, "long tail" and how DAX helps

Written by Kasper de Jonge on 08 January 2013.

Excel extras - PowerPivot CALCULATE() with disconnected slicers

Written by David Churchward on 26 November 2012.

Excel extras - PowerPivot: comparison against average

Written by David Churchward on 13 June 2013.

Excel Opens Up Limitless Possibilities for BI

Written by Chris Webb on 15 July 2012.

Excel with PowerPivot for Custom Dimensions in Reports Blended with EDW Data

Written by Greg Beaumont on 27 August 2012.

Experiments in Linear Regression Land, Part 1

Written by Rob Collie on 20 June 2014.

Exploring PowerPivot for Excel and SharePoint: Blue Yonder Charters

Written by Microsoft on 24 January 2011.

Fact Table Range Groups Created Easily in SSAS Tabular

Written by Anthony Sammartino on 29 November 2012.

Filters aren't applied to related tables in PowerPivot unless a measure is added to the PowerPivot Workbook

Written by John Desch on 16 May 2012.

Filters CAN Flow Up Hill - Via Formulas That Is

Written by Matt Allington on 07 August 2014.

Finding Duplicates in DAX

Written by Teo Lachev on 17 February 2015.

Fiscal Periods, Tabular Models and Time-Intelligence

Written by Gerhard Brueckl on 13 February 2013.

Flat to Star Transformation using DAX Query

Written by Avi Singh on 22 November 2014.

Format the week number in your Power Pivot date table

Written by Erik Svensen on 14 April 2014.

From SQL to DAX: Joining Tables

Written by Marco Russo on 29 April 2015.

Gantt Chart in PowerPivot

Written by David Churchward on 30 August 2012.

• 3
• 4
• 5
• 6
• 7
• 8
• 9