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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Create a month grouping

I need to create a group, always taking a block of 3 months and adding the billing.

 

Nov - Out - Set = 1000

Out - Set - Ag  = 5000

Set - Ag - Jul - 8000

 

renannog_0-1669898835750.png

 

I'm happy if someone can help me!!! 

 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , it better to use a rolling month measure

 

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-3,MONTH))

 

Rolling Months Formula: https://youtu.be/GS5O4G81fww

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.

Top Solution Authors