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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors