Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |