InsureBIAdvocate II10 years agoMoving Average Formula ERROR I have a table of policy coverage and effective date and I am trying to compute a daily moving average of premium. Here is the formula I constructed, utilizing answers to similar questions on this f...Show More
InsureBIAdvocate II10 years agoSean thanks, this works with one change. Replace MAX with EARLIER. Your help is much appreciated.
SeanCommunity Champion to InsureBI10 years agoInsureBI I read your post to mean you want a MovAvg => MEASURE :smileyhappy: So that's what I provided... Apparently you want a Calculated COLUMN so go with Vvelarde's formula
Related contentmoving average helpAverage and Moving AverageMoving AverageMoving AverageAverage formula