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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Mark_Ball
Frequent Visitor

Last 3 month average

Good day,

 

I am looking for a measure where i can average the last 3 months revenue, excluding the most current month. I want to compare July revenue to an average of April, May & June revenue. I do have a separate date table.

 

the measure i tried was:

Revenue 3 Mo Rolling Avg = CALCULATE([TotalRevenue],DATESINPERIOD(DateDim[Date],LASTDATE(DateDim[Date]),-3,MONTH))/3

 

This measure gives me the average for May, June and July. Any ideas?

 

Thank you!

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.