Forum Discussion

seanpratt's avatar
seanpratt
Helper III
6 years ago
Solved

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 b...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.