Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |