Category Archives: 17543

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