Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group Weekly Starting 1/1

Hi,   Is there any way to start a grouping of weeks starting on Jan 1? I have this formula: Date Start of Week = DATEADD(Dates[Date],-1*WEEKDAY(Dates[Date])+weekday(STARTOFYEAR(Dates[Date])),DAY)...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    try this.

     

    Date Start of Week =
DATE ( YEAR ( Dates[Date] ), 1, 1 )
    + QUOTIENT ( DATEDIFF ( STARTOFYEAR ( 'Dates'[Date] ), Dates[Date], DAY ), 7 ) * 7

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support. 

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous 

 

i don't understand what is wrong?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

oh this reply was for the previous comment not yours..