Calculate if user is active

wingsted93 — Fri, 08 Jan 2021 10:34:31 GMT

I'm trying to get a monthly overview of users enrolled. As of now I can only see the current number of active users, but would like to go back in time, and see how many enrolled users we had each month. The data (in danish) looks like this:

The highlighted coloum represents a boolean value to check if the user is active. This is basically done by evaluating the "afgangsdato" coloumn which states the day the user got inactive. How can i get the number of active users for each month?

Re: Calculate if user is active

amitchandak — Fri, 08 Jan 2021 10:45:19 GMT

wingsted93 , seem like very similar case like my he blog with start and end date . Check if that can help you

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

https://www.youtube.com/watch?v=e6Y-l_JtCq4

topic Calculate if user is active in DAX Commands and Tips

Calculate if user is active

Re: Calculate if user is active