Forum Discussion
Rolling Measure Total
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...
Not entirely. But, have you checked out the Running Total quick measure?
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