Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

DAX to select 1 log in per month per employee

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.

3 REPLIES 3
Anonymous
Not applicable

I have tried this however, it is just giving me a distinct count of employees who logged in on each date.

Anonymous
Not applicable

HI

 

Try on a measure:

Distincount(Table[employee #]) 

Anonymous
Not applicable

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.