Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Running Total with previous month value

Hello guys,

 

EDIT: I added more details to my question:

Thanks to Anonymous I was able to solve my previous problem: 

Solved: Previous Month value - Microsoft Power BI Community


But now something else came up and I have been trying for days to solve the problem.

Based on the previous solution I am trying to create a running total, but it doesn't work as expeceted. 

 

Since I am not able to show you the actual viusal I edited the screenshot of the previous post:

 

As you can see running Total does not calculate the value of the column "measure".

 

 

For column "measure" I am using the solution of the last post.

This meausre allows me to fill my missing value with the previous one. (Septemeber value == august value)

 

Now I am trying to figure out the running total.

 

This is what my Data looks like: 

 

Can anybody help me with that ? 

 

 

 

 

 

 

 

 

 

 

Need Help

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    If you are looking for the Year-To-Date type of running total, please check the below picture and the attached pbix file.

     

     

     

     

     

    Running total Year To Date: =
IF (
    NOT ISBLANK ( [Value sum measure:] ),
    CALCULATE ( [Value sum measure:], DATESYTD ( 'Calendar'[Date] ) )
)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      sadly that's not it 😞 

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi Anonymous ,

     

    try this

    RT =
    VAR MaxDate = MAX('Facts31'[Date])
    RETURN
    CALCULATE(
             SUM('Facts31'[Value]),
             'Facts31'[Date]<=MaxDate
    )
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      That did not work for me :'(