Forum Discussion

DonalMc's avatar
DonalMc
Icon for Advocate II rankAdvocate II
8 years ago

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

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

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

    • DonalMc's avatar
      DonalMc
      Icon for Advocate II rankAdvocate II
      8 years ago

      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