|Modeling Viral and Marketing Growth, Part 3 of 3|
|Written by Rob Collie|
|Friday, 25 January 2013 17:28|
This is a question I should have answered before I even started down this road.
To be honest, I did it primarily as a challenge - to stretch my brain a little bit. If I were faced with this exact same task in my daily work, undoubtedly I would just use normal Excel formulas. In some ways, this modeling exercise has been a deliberate misuse of PowerPivot. A handful of parameters with no source data whatsoever - this is NOT what the PowerPivot engine was built for, which explains why the PowerPivot solution is actually significantly more difficult than the Excel solution.Read more...
Latest Author Articles
- Schrodinger s Pivot, or Why CALCULATE() Should Be Your Favorite Function EVER.
- Repeat Customers in DAX: Three Flavors
- Displaying Top N, Bottom N, and "All Others"
- Blending "Time of Day" Analysis with Calendar/Date Analysis
- SUMX of IF: A Perfect Blend of Simple and Sophisticated