Rolling Measure Total

[DonalMc]

Hi Folks,

I have an issue with averaging a rolling measure. See table below

Say my MQL to SQA conversion ration is defined as follows

MQL to SQO % MbM = CALCULATE(DIVIDE([SQOs],[MQL 2 Mth Avg]))

And

MQL 2 Mth Avg =

CALCULATE (

    [MQLs Count],

    DATESINPERIOD ( '7_Date'[Date], LASTDATE ( '7_Date'[Date] ), -2, MONTH )

)

    / 2

How do I get the [MQL to SQO % MbM] % for the months shown?  

I guess the question really is, how to I get the [MQL 2 Mth Avg] total to actually total instead of using the measure?

Does that make sense?

Thanks,

Donal

[Greg_Deckler]

Not entirely. But, have you checked out the Running Total quick measure?

[DonalMc]

Hi smoupre,

Thanks for getting back to me. I tried the below, added it to the matrix and it gave me the exact same result as is already in the [MQL 2 Mth Avg].

MQL 2 Mth Avg running total in Date =
CALCULATE(
[MQL 2 Mth Avg],
FILTER(
ALLSELECTED('7_Date'[Date]),
ISONORAFTER('7_Date'[Date], MAX('7_Date'[Date]), DESC)
)
)

Thanks,

Donal