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
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi ThomasT 

whats your current statement?

it should be smth like

measure = 
var _curDate = MAX(Table[Date])
RETURN
CALCULATE(SUM(Table[EAC]), Table[Date] <= _curDate)
ThomasT's avatar
ThomasT
Frequent Visitor
6 years ago

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

  • 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?