Forum Discussion

ThomasT's avatar
ThomasT
Frequent Visitor
6 years ago

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 Ra...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi ThomasT ,

 

You may create measure like DAX below.

 

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

 

Best Regards,

Amy 

 

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.

ThomasT's avatar
ThomasT
Frequent Visitor
6 years ago

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?