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

Cooking With CUBEs

Microsoft sneaked a couple of ne As we should all know by now, PowerPivot provides Excel with a powerful way to harness data from one or more sources, and to do further analysis on that data within familiar pivot tables. Furthermore, because PowerPivot is creating an in-memory cube of the data, it is possible to build an analysis using CUBE formulae. I have blogged a couple of times about CUBE formulae, in Cycling Through The Fog and in Cracking The Code. In Excel, as with any development, you want your solution to be as flexible and dynamic as possible. This … Continue reading Cooking With CUBEs

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