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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

How to calculate the moving total over a 14 day period when I have several groupings?



I have a table that is currently formatted in this way:


CountryProductDateStore CentrePayment ProviderClientTransaction TypeTotalProject


I also have a DimDate table.


I would like to know how I can get the moving sum of all transactions (over 14 days) in the last column that match the day in the table. Unfortunately my attempt has not been very successful:

14 Days:=CALCULATE(sum('All Transactions'[total]),
) , VALUES('All Transactions'[Country])

What this returns is just the last 14 days' total values (not as a running total either. Any ideas on how to address? 



Another thing: I believe an area where this is messing is when there is no directly previous day record for a certain country/client. I.e. 

Country | Total
Canada | 32 | Jan 1

USA | 31 | Jan 1

Canada |43| Jan 2
Canada |32| Jan 3

USA |35 | Jan 3

There needs to be a special consideration for the fact that on the 2nd we had no US sales. 

Community Support
Community Support

Hi @20170120,


Please check if this article meet your requirement: Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot.


If it doesn't meet your requirement, please share sample data and screenshots about the desired results.


Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Prodigy
Post Prodigy




Running Total = Calculate(Sum(Sales), DATESINPERIOD(DateTable[DateKey], TODAY(), -14, DAY).

That gives me the same results as my first formula.

Added some more information to the OP.



Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors