Count number of days an employee was active

[Anonymous]

Hello

I have a data table that lists all actions taken by each employee and the dates taken. I would like to create a measure that counts the number of days within any given time period that an employee was taking any action ,and not count days where there is no action listed. For example, say I have the following data table:

I would like to create a visual using a measure showing number of days with actions taken (days "worked"), like this:

For some reason this one is just not clicking for me. 😞 Thanks in advance!

[littlemojopuppy · Accepted solution]

Create a measure for days worked like this: Days Worked = DISTINCTCOUNT([DailyLog].Date)

Drop employee into columns on the visual, Year/Month into column and that measure into value.

[Anonymous]

I was making it wayy too hard on myself! Thank you! 🙂

[littlemojopuppy]

De nada!  Glad I could help!  😊