Forum Discussion
seanpratt
Helper III
Helper IIICounting 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...
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
Community Champion
Community ChampionUse WEEKNUM then it should pretty much be like month to month.