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]))

     

     

     

schoden's avatar
schoden
Post Partisan
6 years ago

Hi AllisonKennedy  Thanks for getting back ... You explained very well it to why ALL will not work here as I have other filters applied 🙂  

I tried with date table too , since it didnt pop up any dates , so I went with orginal table dates , here it

is Date_entered. 

 

But I am confused what shall I put in the interval arguments if I am to use DATESINPERIOD?

 
       
   
v-diye-msft's avatar
v-diye-msft
Community Support
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]))

 

 

 

  • schoden's avatar
    schoden
    Post Partisan
    6 years ago

    v-diye-msftThanks a lot ...It worked for me with your DAX.... ALL and ALLSELECTED Difference 😄  Fabulous 😄