Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Running Total past current date

Hi Power BI Users,

Below is a sample table visual, where all attributes are Measures:


Actuals = Sum(Actuals)

Burn Rate Avg = Avg of last 6 months

Burn Rate EAC = If Date<Today, Actuals,Burn Rate Ave

Running Burn = Running Total acorss Burn Rate EAC.



As you can see the Running Burn goes up to May then remains at the May figure for the remainder on the months. 


What I want to achieve is for the Running Burn to cumulative the EAC all the way to Dec.


That is Jun = 87.37+20.89 = 108.26; Jul = 108.26+20.89 = 129.15 and so on...


Is there a way to achieve this result?



Community Champion
Community Champion

Hi @ThomasT 

whats your current statement?

it should be smth like

measure = 
var _curDate = MAX(Table[Date])
CALCULATE(SUM(Table[EAC]), Table[Date] <= _curDate)

do not hesitate to give a kudo to useful posts and mark solutions as solution
Frequent Visitor

I gave the DAX formual a try and it is returning total which begins several years in the past.  I want the Jan figure to be starting from the current year and do a running total from that point

Hi @ThomasT ,


You may create measure like DAX below.


fins_Running_Burn =
    SUM ( Table1[fins_Burn_EAC] ),
    FILTER (
        ALLSELECTED ( Table1 ),
        YEAR ( Table1[Date] ) = YEAR ( MAX ( Table1[Date] ) )
            && MONTH ( Table1[Date] ) <= MONTH ( MAX ( Table1[Date] ) )


Best Regards,



Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank for the reply.


If you see my table for the months of June to December, it is the same.  Why is this?


Is there a way to make the running total to apply for these months as well?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors