Counting Employees by Week

[seanpratt]

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!

[Anonymous · Accepted solution]

@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.

[Greg_Deckler]

Use WEEKNUM then it should pretty much be like month to month.

[PBIfanatic]

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?