Forum Discussion

michaelpop's avatar
michaelpop
Regular Visitor
6 years ago
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....
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    I answered a similar question of yours here.  Did that not work?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Ashish,

       

      I managed to resolve by creating a Quick Measure from the variable of counts, for example, below DAX

       

      Running count in Year =
      CALCULATE(
          COUNTA('data1'[level]),
          FILTER(
              ALLSELECTED('data1'[Year]),
              ISONORAFTER('data1'[Year], MAX('data1'[Year]), DESC)
          )
      )