Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Sum a item by week

Hi everyone, 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 Staff Hours spent date A 5 ...

Need Help

Greg_Deckler
7 years ago
Should be able to use WEEKNUM to get a grouping of rows by week. Also, see my quick measures involving week here:

https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=forum-board:QuickMeasuresGallery&q=week

Greg_Deckler

Community Champion

7 years ago

Should be able to use WEEKNUM to get a grouping of rows by week. Also, see my quick measures involving week here:

https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=forum-board:QuickMeasuresGallery&q=week

Forum Discussion

Sum a item by week

Related content

Current week vs last week sum

Sum per Week

Measure displaying last week sum

Running sum

Filtering a Sum