Forum Discussion
Solved
running total
I need a running total organisation body count for a Human Resources Report. I have an employee name, date started and end date. If an employee end date column is blank they are a current employee....
Refer
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
amitchandak thanks for this. Although I'm still trying to create a cumulative total such as the right hand column in the below example:
| name | start date | end date | start count | end count | count total | cumulative total |
| bob | 1/01/2018 | 1 | 0 | 1 | 1 | |
| john | 1/01/2018 | 1/05/2018 | 1 | -1 | 0 | 1 |
| bill | 1/03/2018 | 1 | 0 | 1 | 2 | |
| fred | 1/05/2018 | 1 | 0 | 1 | 3 | |
| sam | 1/05/2018 | 1/05/2018 | 1 | -1 | 0 | 3 |
| david | 1/02/2019 | 1 | 0 | 1 | 4 | |
| tony | 1/03/2019 | 1 | 0 | 1 | 5 | |
| jane | 1/05/2019 | 1 | 0 | 1 | 6 | |
| 8 | -2 | 6 |