Conditional running total

[Anonymous]

I am trying to get a running total of translated words in progress and subtract the words in progress once they are completed. 

Running Total Measure = CALCULATE(SUM(DataDump1[Calc Words In Progress]),
                                                    FILTER(ALL(DataDump1), DataDump1[Sent To Language Teams] <=

                                                          MAX(DataDump1[Sent To Language Teams])
                                                                      && YEAR(DataDump1[Sent To Language Teams] =

                                                                               YEAR(DataDump1[Sent To Language Teams]))))

I am not sure if I can use a date slicer to get what I am looking for. I have tried and am not able to get the result I want. 

I was hoping someone can help me edit the formula above or explain how this can be done so I can see how many translated words are in progress based off how many words a person can translate in a given month. 

Thank you in advance for all the help and advice you can give!

[Anonymous · Accepted solution]

@v-juanli-msft

Thank you trying to help. I was able to find the solution. I had it all along I just had to put the date slicer as a visual and it worked. 

[Anonymous]

Hi, @v-juanli-msft Thank you for responding.

I am trying to take the running total that I have calculated but subtract the translated words in progress from the running total after a certain date. 

The example data:

translated words in progress	start date	Delivery date
2500	1/2/2018	1/15/2018
3200	1/5/2018	1/25/2018
3000	1/10/2018	1/25/2018
2000	1/25/2018	2/15/2018
2500	2/5/2018	2/25/2018
1500	2/10/2018	3/1/2018
1000	3/5/2018	3/26/2018
5000	3/15/2018	4/2/2018
6000	3/30/2018	4/20/2018

So I want to create a graph that shows the running total of translated words in progress. However, when the date for delivery date passes. I want the number of translated words in progress to subtract from the running total. 

Example, on 1/10/2018 I want the running total to show 8,700. Which it does in the formula I have posted in the original post. This next step is where I am confused on how to perform this. 

I want to use a slicer on delivery date and look at words in progress after a certain date. For example, I want to look at a date period from 1/16/2018 to Today. Since I am not looking at 1/15/2018 I want 2,500 to subtract from the running total. I should see 6,200 for the running total now. 

I hope I have made it a little more clear as to what I am trying to accomplish. If not I can try explaining it a different way. 

Thank you for your help and looking into this issue for me. 

I am new to power bi and trying to learn all this while building this report. So any help or tips are much appreciated and welcomed! 🙂

[v-juanli-msft]

Hi @Anonymous

How do you mean "use a date slicer to get what I am looking for"?

What is the condition of running total?

Best Regards

Maggie