monthly count of rows from current month data

[Ramees_123]

I have vistor details table which have the logined user details based on the date, for finding the new user for the month, i created one table storing only current month user details and the other table storing user details till last month. this two table i found the new users= except(current month,till last month)

Now i need to create line chart which should show the monthly new users trend. Is it possible if we are using this logic, is there any other logic to find the new users and this trend graph.

eg: In Aug how many new users, september how much like that.

[v-stephen-msft]

Hi @Ramees_123 ,

Here's my solution:

The sample data is as follows. The ID of each login and the date of login.

1.Create a calculated column to determine whether it is the first login. The time of the first login is the time when the new user logs in.

First login =
var _min=CALCULATE(MIN('Table (2)'[Date]),ALLEXCEPT('Table (2)','Table (2)'[ID]))
return IF([Date]=_min,1)

2.Create a line chart. The [First login] column selects the aggregation operation to count.

You can check more details from the attachment.

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.

[Ramees_123]

Thanks for sharing this solution.

In My requirement there are 3 different sites to visit, Dashboard, SOP, Policy, if one person logined in the three sites in same day its giving 1 for both, how to overcome from this

[v-stephen-msft · Accepted solution]

Hi @Ramees_123 ,

 Add the field name of the site in ALLEXCEPT().

First login = 
var _min=CALCULATE(MIN('Table (2)'[Date]),ALLEXCEPT('Table (2)','Table (2)'[ID],'Table (2)'[Site]))
return IF([Date]=_min,1)

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.

[lbendlin]

You can use exactly the same measure, it will work correctly across all months in your visual. "Current"  and "Previous" are concepts that apply in all filter contexts.  "Current"  means the cell or data point you are currently rendering, not necessarily "september 2021" . 

[Ramees_123]

Please give me more idea on that.

[lbendlin]

Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good).