Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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                      1/7/2019

A         6                       3/7/2019

A         8                       8/7/2019

A         9                       10/7/2019

B         3                       2/7/2019

B         6                       3/7/2019
B         6                       9/7/2019
B         7                       10/7/2019

 

My expected result like the following.

 

Week 1 1/1/2019 - 7/1/2019

A 11 Hours

B  9 Hours

 

Week 2  8/7/2019 - 14/7/2019

A 17 Hours

B 13 Hours

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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=fals...

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

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=fals...

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.