Monthly Users Count for Total Users and New Users and Expired users

[rock_stage_user]

Hello, I am facing issues while calculating the users count,I want a total users start of the each month 

I have data view like

from this i want data based on user creation date for total count of users begining of the month.

can somebody please help me out.

[JoeBarry]

Hi @rock_stage_user 

You can try the following. create 2 measures for both. I presume you are using the created_on date as the month/year?

Create a running total. from @Greg_Deckler 

Running Total = 
VAR _MaxDate =
    MAX ( 'Table'[created_on] )
VAR _Table =
    Filter(ALLSELECTED('Table'), [created_on] <= _MaxDate)
RETURN
    COUNTX(_Table, [USERID])

Then Create another measure to get the value of the previous month. You will need a date table here https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables 

Total Users beginning of the month = Calculate([RunningTotal], DATEADD('DIM DATE'[Date]), -1 MONTH)

For the Users added in Month

New Users = DISTINCTCOUNT(Table[UserID])

Add the last two measure to visual

Thanks

Joe

[rock_stage_user]

Thank you so much, Joe for solution, i have total users count  for previous year also

like in till december 2022 i have total 400 suppose and that will be continue with next year begining like that i need.

[JoeBarry]

No problem @rock_stage_user  If you're happy with the solution please mark it as correct

Cheers