Forum Discussion
Determine Active Clients At Any Point in Time
Thanks! It took me a while and quite a lot of tries and versions, but I made it work!
Sure! I use this calculation all of the time now. It usually looks something like this:
ActiveClients =VAR MinDate = FIRSTDATE('Date'[Date])VAR MaxDate = LASTDATE('Date'[Date])RETURNCALCULATE (DISTINCTCOUNT('CombinedTables'[PersonalID]),'CombinedTables'[EnrollmentEnd]> MinDate,'CombinedTables'[EnrollmentStart] <= MaxDate)
heatherkw there are lot of blogs/videos about this. if you search for employee head count (common scenario) DAX, you will find a solution.
Here is one, I'm not endorsing any solution because I don't know how they will perform. Here is one example link Employee Head Count Over Time | Power BI Exchange (pbiusergroup.com)
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Thanks! It took me a while and quite a lot of tries and versions, but I made it work!
Would you please share your solution with the community? After all, this is why this community exists
Sure! I use this calculation all of the time now. It usually looks something like this:
ActiveClients =VAR MinDate = FIRSTDATE('Date'[Date])VAR MaxDate = LASTDATE('Date'[Date])RETURNCALCULATE (DISTINCTCOUNT('CombinedTables'[PersonalID]),'CombinedTables'[EnrollmentEnd]> MinDate,'CombinedTables'[EnrollmentStart] <= MaxDate)