|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
- So Your Detailed/Flat Pivot is Slow and Doesn't Sort Properly? Try Text Measures!
- Excel 2016: Ten Heartwarming Improvements
- RANKX-apalooza: Within and Across Groups, With Filters, Etc.
- Schrodinger s Pivot, or Why CALCULATE() Should Be Your Favorite Function EVER.
- Repeat Customers in DAX: Three Flavors