quick measure issue

[Maureen]

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 the quick measure menu but when I look at the DAX formulas produced by quick measure - I see that they are slightly different (see below).   I cannot figure out what I may have done differently in the quick measure menu to get the DAX formula on the left or if it is just somewhat "buggy" and produced two different formulas.  Now - I can't reproduce the formula on the left - I am just trying to understand it so I can explain to my students why two different formulas/results  were produced.  Any ideas?

[amitchandak · Accepted solution]

@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 · Accepted solution]

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

[amitchandak · Accepted solution]

@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]))))  

[Anonymous]

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]

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.