Forum Discussion

jonahlawson's avatar
jonahlawson
Frequent Visitor
3 years ago

Rolling Count By Date

I have a data set of a list of people within an organization with columns stating who they are, when they were hired and a column on their temrination date if they left the organization. I am working...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jonahlawson ,

 

I created a sample data to restore your data.

Here's the measure which counts the number of active people. In the FILTER() function, "[Hired Date] <= TODAY ()" is to prevent future recruits from appearing in the data sheet.

Number of active people =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Person ID] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Left Date] = BLANK ()
            && [Hired Date] <= TODAY ()
    )
)

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.