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]))
MQL 2 Mth Avg =
DATESINPERIOD ( '7_Date'[Date], LASTDATE ( '7_Date'[Date] ), -2, MONTH )
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?
Not entirely. But, have you checked out the Running Total quick measure?
Proud to be a Datanaut!
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)))
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.