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 … Continue reading PowerPivot BlogRoll – 23rd December 2012

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 PowerPivot – bit.ly/T0nRMi Set Up a VM Test Server for PowerView and PowerPivot – bit.ly/R0QY3s Hide Calculated Items With Zero Totals In PowerPivot PivotTables – bit.ly/12tBW8W Book Review: DAX Formulas For PowerPivot – bit.ly/12hDDXR Creating a Spacer Column in a PowerPivot PivotTable – bit.ly/T2bMHu