Complex Customer Cohort Retention Using PRODUCTX
OK OK. time to circle back to one of my only "defeats" EVER, and settle the score! Yes, this problem. well it beat me up pretty badly about 18 months ago. I eventually solved it, but not in a way where the formula was even remotely explainable or maintainable. I've done some posts about exponential growth forecasting before. In both of those posts, I used the POWER() function to multiply out the increasing or decreasing series. (10 percent growth each year, for five years translates to 1.10 raised to the 5th power). But both of those posts assume the growth factor is STATIC. Meaning, if you forecast 10 percent growth per period, it's 10 percent growth for EVERY period. That nice, steady percentage allows us to use the POWER function to handle all the multiplication.
Tags: dax