Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
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
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
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 ,
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.
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |