Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Good morning, I am extremely new to Power BI and was wondering if I could get some assistance. (This is probably very basic)
I'm working on a report, and I need to figure out how many distinct users are logging into a system. These employees log into this system multiple time a day, but I just need one log in per month.....
My table consists of employee #, Date of log ins, and URL of the system. I also have it connected to a date table.
I have tried this however, it is just giving me a distinct count of employees who logged in on each date.
HI
Try on a measure:
Distincount(Table[employee #])
I have tried this, however it is giving me a count of distinct users per day. I guess what I'm actually looking for is the first log in of each employee, for each month
User | Count |
---|---|
8 | |
8 | |
5 | |
4 | |
3 |