October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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.
If I attribute a "1" to an employee with a start date and "-1" to an emplyee with a end date i can calculate the current body count.
What I can't figure out is a running total to watch the total body count fluctuate over time.
Any help would be appreciated !
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
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
Hi
Still not resolved, please assist. thanks
Can you explain how to do a cumulative or running sum of counts of text data between selected dates. For instance, I have multiple years of data by years and months. The data includes a column containing text, say “M”, “L” etc…. I need to draw a chart showing both counts and running counts by months. And use a slicer to select a year, once I select a specific year then I should be able to visualize the counts and running counts of text of the selected year. So running counts should be for a selected time say a year, we may use Min and Max date var for a selected year.
Hi,
I answered a similar question of yours here. Did that not work?
Thanks Ashish,
I managed to resolve by creating a Quick Measure from the variable of counts, for example, below DAX
@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 |
Hi,
You may download my PBI file from here.
Hope this helps.
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |