Forum Discussion
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 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?
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]))))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
4 Replies
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
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.
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]))))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
