Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
5 years ago
Solved

DAX Table Summary By Week

Hi all,

 

How can I create a DAX table which summarises the below data by week?

 

The DAX table would have a sum of each candidates rest time by week.

 

Week, Candidate, Sum of Rest Time

 

Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi HenryJS ,

     

    You can create a weeknum column in your table:

     

     

    weeknum = "WEEK"&WEEKNUM('Table'[Date],2)

     

     

    Then create summarize table:

     

     

    Table2 =
SUMMARIZE (
    'Table',
    'Table'[Worker Name],
    'Table'[weeknum],
    " Sum of Rest Time", SUM ( 'Table'[Rest Time] )
)

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai