Sum a item by week

Question

Hi everyone,&nbsp;I have a problem to analyzing the following data. I am not sure how to write DAX statement. ANd Do I need a Date table? Many thnaks&nbsp;Staff&nbsp; &nbsp; Hours spent&nbsp; &nbsp; &nbsp;dateA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/7/2019A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3/7/2019A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/7/2019A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/7/2019B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/7/2019B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3/7/2019B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9/7/2019B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/7/2019&nbsp;My expected result like the following.&nbsp;Week 1 1/1/2019 - 7/1/2019A 11 HoursB&nbsp; 9 Hours&nbsp;Week 2&nbsp; 8/7/2019 - 14/7/2019A 17 HoursB 13 Hours&nbsp;&nbsp;

greg_deckler · Accepted Answer

Should be able to use WEEKNUM to get a grouping of rows by week. Also, see my quick measures involving week here:
&nbsp;
https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&amp;allow_punctuation=false&amp;filter=location&amp;location=forum-board:QuickMeasuresGallery&amp;q=week
&nbsp;

Forum Discussion

Sum a item by week

1 Reply

Related content

Current week vs last week sum

Sum per Week

Measure displaying last week sum

Running sum

Filtering a Sum