Forum Discussion

InsureBI's avatar
InsureBI
Icon for Advocate II rankAdvocate II
10 years ago

Moving 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...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

 

MovAvg = CALCULATE(AVERAGE(Policy[Coverage]),FILTER(ALL(Policy),Policy[EFF_DATE] <= EARLIER(Policy[EFF_DATE])))

InsureBI's avatar
InsureBI
Icon for Advocate II rankAdvocate II
10 years ago

Thanks.

 

So you are suggesting that I drop the table reference to the calculated measure.  I did and got the same error message.