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
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

InsureBI Try these MEASURES

 

SumCov MEASURE =
CALCULATE (
    SUM ( Policy[Coverage] ),
    FILTER ( ALL ( Policy ), Policy[Eff_Date] <= MAX ( Policy[Eff_Date] ) )
)

MovAvg MEASURE =
DIVIDE (
    [SumCov],
    CALCULATE (
        COUNTROWS ( Policy ),
        FILTER ( ALL ( Policy ), Policy[Eff_Date] <= MAX ( Policy[Eff_Date] ) )
    ),
    0
)
InsureBI's avatar
InsureBI
Icon for Advocate II rankAdvocate II
10 years ago

Sean thanks, this works with one change.  Replace MAX with EARLIER.

 

Your help is much appreciated.

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    InsureBI 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