Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
I was making it wayy too hard on myself! Thank you! 🙂
De nada! Glad I could help! 😊
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |