cancel
Showing results for
Did you mean:
Frequent Visitor

## 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 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

2 REPLIES 2
Super User

## Re: Rolling Measure Total

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

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Frequent Visitor

## Re: Rolling Measure Total

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

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 39 members 1,037 guests
Recent signins: