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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

Rolling SUM by Month within in Each Quarter



I have been trying to get the rolling sum for months within each quarter. I have tried multiple ways but nothing seems to be working. I am looking to create a measure or a column that gives me the values as below:


My Expected output is :
If selected Year =2022 and Month = December , I need the rolling sum for the Q4 which includes sum of oct, Nov and Dec since December belongs to Q4. IF i Select November i need rolling sum for Oct and Nov which are part of Q4. and hence forth.

If i select 2022, feb the output should be sum of jan and feb 

Super User
Super User

Your data model has a calendar table?  That table includes the Year-Quarter column?

Hi ,


Yes, the model do have a calendar table. I found the solution Ibendlin. Unfortunately its very easy one using TOTALQTD.



This gave me the rolling sum of months within each quarter

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.