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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.