cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## monthly count of rows from current month data

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.

1 ACCEPTED SOLUTION
Community Support

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.

6 REPLIES 6
Community Support

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.

Helper IV

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

Community Support

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.

Super User

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" .

Helper IV

Please give me more idea on that.

Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.