Forum Discussion

Maureen's avatar
Maureen
Helper III
6 years ago
Solved

quick measure issue

    I created a 3-month rolling average twice, both in the quick measure menu, with the same column and got two very close but slightly different results.   I thought I entered the same options in ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Maureen 

    The first one seem like rolling 3 with -2 +1. I typically use this kind of formula

    Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-12,MONTH)) 
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],MAX(Sales[Sales Date]),-12,MONTH))  
Rolling 30 day = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],MAX(Sales[Sales Date]),-30,Day))  

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],MAX(Sales[Sales Date]),-3,Day))  

Rolling 4 week same week day = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX(Sales[Sales Date]),-28,Day),filter(Date, WeekDay('Date'[Date])=max( WeekDay('Date'[Date]))))
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Maureen ,

     

    It may because you enter different value of  “ Periods after” when you create the quick measure.

     

    For the left formula you shared:

     

     

     

     

    For the right formula you shared:

     

     

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Maureen ,

 

Was it for the same visual or for different visuals?  What was the other conditions , filters on the visuals when creating the quick measures?

 

Cheers

 

CheenuSing

  • Maureen's avatar
    Maureen
    Helper III
    6 years ago

    It was the same visual.  I simply made a table (a visual table) and brought both of the quick measure results into the table to compare so there were no other conditions set.