Create a meassure that increases along with time

[Anonymous]

Hi there!

I'm pretty new to Power BI and I'm trying to get a meassure from a list of users that check monthly the amounth of users that are active, however I have only achieved to get the active users on each month, but not the whole group of them in those specific months. All I could reach is something like the line below, but the result was far from positive:

active users = CALCULATE(Count(TABLA[key]), FILTER(ALL('TABLA'),TABLA[Discharge date]<=MAX(TABLA[entry date])) - [users that quitted] )

I would really appreciate your help.

Thank you

[Anonymous]

Thanks a lot! it was super useful, exacly what I needed 😄

[amitchandak · Accepted solution]

@Anonymous , I think you need same approch as this blog

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