Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Pbiuserr
Post Prodigy
Post Prodigy

What quick measure is that?

Hello

I've encounter such measure and I am not sure which one is that. I can see its not rolling average cause it computes another way. It claims to be 12 months rolling average. What this code does? calculates average from 12 months from datastamp (month-year lets say), so for instance on May 2022 it will give result of 12 months average value? or what

 

IF(
ISFILTERED('Fact Table'[Period]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __LAST_DATE = ENDOFMONTH('Fact Table'[Period].[Date])
VAR __DATE_PERIOD =
DATESBETWEEN(
'Fact Table'[Period].[Date],
STARTOFMONTH(DATEADD(__LAST_DATE, -12, MONTH)),
__LAST_DATE
)
RETURN
AVERAGEX(
CALCULATETABLE(
SUMMARIZE(
VALUES('Fact Table'),
'Fact Table'[Period].[Year],
'Fact Table'[Period].[QuarterNo],
'Fact Table'[Period].[Quarter],
'Fact Table'[Period].[MonthNo],
'Fact Table'[Period].[Month]
),
__DATE_PERIOD
),
CALCULATE(
SUM('Fact Table'[Value]),
ALL('Fact Table'[Period].[Day])
)
)
)

2 REPLIES 2
olgad
Super User
Super User

Hi, 
it is 12 month rolling average.

 

If you look at Feb 2023 then you see the sum of the last 12 months divided by 12. 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Why quick measures produce another result when I try to recreate rolling average?
how to establish such measure with traditional calendar table? Like that?

Pbiuserr_0-1676289375529.png

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors