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
VvelardeCommunity Champion10 years ago MovAvg = CALCULATE(AVERAGE(Policy[Coverage]),FILTER(ALL(Policy),Policy[EFF_DATE] <= EARLIER(Policy[EFF_DATE])))
InsureBIAdvocate II to Vvelarde10 years agoThanks. So you are suggesting that I drop the table reference to the calculated measure. I did and got the same error message.
Related contentmoving average helpAverage and Moving AverageMoving AverageMoving AverageAverage formula
