Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Any ideas on this?? Thanks for your help!
Please post sample data
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.
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
114 | |
44 | |
44 | |
28 | |
22 |