Forum Discussion
Counting Employees by Week
How do I go about creating weekly measures? I'm trying to create a week over week table that shows our employees attendance during COVID-19? I've done this type of work before with month over month but weekly, I can't seem to get it figured out.
My measure is basically Employees = COUNTROWS('Employees'). I'd like to create counts of all employees week to week (my week starts Sunday.
Can someone please help 🙂
Thanks!
seanpratt
Try something like this:Create a weeknumber column first, use that column to create the measure.
Weeknum column = WEEKNUM([Date of Creation],1) Measure = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),SUMX(FILTER('Table',EARLIER('Table'[Weeknum])='Table'[Weeknum]),1)))Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi seanpratt ,
More information will be helpful, can you give some sample data?
Do you have a date and employee table connected to your attendance table?
Use WEEKNUM then it should pretty much be like month to month.
seanpratt
Try something like this:Create a weeknumber column first, use that column to create the measure.
Weeknum column = WEEKNUM([Date of Creation],1) Measure = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),SUMX(FILTER('Table',EARLIER('Table'[Weeknum])='Table'[Weeknum]),1)))Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
