Forum Discussion
Count first time user logs in
I have a table with a list of users and the dates they logged into a website. I want to calculate the number of new users which would be counting them the first time they logged in. This way my date slicer would filter the number of new users based on a date range. Im not sure how to accomplish this.
3 Replies
I can't, it's confidential information. its literally a table with two columns, one column is the user names, the second is the login date. Obviously the user will be seen multiple times in the table if they have logged in more than once. We have been collecting the data for over a year. so i can do a distinct count which gets me total unique users but not new users. I can work with it in power querry and sort and deduplicate but I want to do it in a calculation so that I can have other columns for slicing the data.
If you really need a sample data I can recreate a fake one with fake data i type in.
Any ideas on this?? Thanks for your help!
