Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DonalMc
Advocate II
Advocate II

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
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.