cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DonalMc Frequent Visitor
Frequent Visitor

Rolling Measure Total

Hi Folks,

I have an issue with averaging a rolling measure. See table below

 

pbi-table.png

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

DonalMc Frequent Visitor
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

Helpful resources

Announcements
Virtual Launch Event

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

Power BI Helps Homeless and Trouble Youth

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 39 members 1,037 guests
Please welcome our newest community members: