Forum Discussion

schoden's avatar
schoden
Post Partisan
6 years ago
Solved

Running Total

Hi Experts,    I have been spending last 2 hours on this formula and it doesnt seem to work still. Please help.    I needed a running Total for the actual Hours from Many sided Table( With date E...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi schoden 

     

    Try this one?

     

    Running total = calculate(sum(V_PM_project(Hours_actual),Filter(ALLSELECTED(V_PM_project),[date_entered]<=max(V_PM_project'[date_entered]))

     

     

     

AllisonKennedy's avatar
AllisonKennedy
Community Champion
6 years ago
If you use DATESINPERIOD you would do something like -3, YEAR) for the number of intervals and interval, depending on how far you want the running total to go back in time.

Another option could be to use DATESBETWEEN() and just provide start and finish dates
schoden's avatar
schoden
Post Partisan
6 years ago

Thank You for sharing your knowledge .... As a new Power BI Learner , its very helpful 😄 

I have resolved this issue , Thanks