Category Archives: 17544

PowerPivot BlogRoll – 23rd December 2012

PowerPivot activity announced on Twitter for the week ending 23rd December 2012.

 

Using HASONEVALUE in a DAX IF statement – bit.ly/TVMwA7

Create a memory-efficient Data Model using Excel 2013 and the PowerPivot add-in – bit.ly/ZfaRsf

Introduction to MDX for PowerPivot Users, Part 5: MDX Queries – bit.ly/12wLGQI

[Update] What is using all that memory on my Analysis server instance? – bit.ly/T51Hsc

Running Product in DAX: Calculating Portfolio Returns – bit.ly/XOobxz

The CALCULATE Function—New DAX Video Tutoria – bit.ly/XTTirq. Note that this is a subscription site.

Dynamic CUBE Formulae In Excel – bit.ly/R6Fnjs

The Ballad of Ken Puls, DAX Convert – bit.ly/RLv1ac

DAX Spicy Scale Survey – bit.ly/RbtqZC

PowerPivot BlogRoll – 16th December 2012

PowerPivot in Excel 2013 – bit.ly/V1jN01

How PowerPivot can help financial reporting –bit.ly/T0o1Dj

Importing your SalesForce data directly into PowerPivotbit.ly/T0nRMi

Set Up a VM Test Server for PowerView and PowerPivotbit.ly/R0QY3s

Hide Calculated Items With Zero Totals In PowerPivot PivotTables – bit.ly/12tBW8W

Book Review: DAX Formulas For PowerPivotbit.ly/12hDDXR

Creating a Spacer Column in a PowerPivot PivotTable – bit.ly/T2bMHu