Forum Discussion

jnrezk's avatar
jnrezk
Helper III
5 years ago

Calculating Week Start Date from Week Number

Hi there, I have data by week number like this: but I need to add a column that will show me the week end date like this format:   The other complication is that the week numbers are ...
Need Help
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI jnrezk,

      I modify the optional format to '2' and add the offset '-1' to the expression, then it will get the Sunday as result from the 'Monday to Sunday' week regular:

      WeekStart = 
MINX(
    FILTER (
        CALENDAR (
            DATE ( LEFT ( [ISO Week of ISO Year], 4 ), 1, 1 ),
            DATE ( LEFT ( [ISO Week of ISO Year], 4 ), 12, 31 )
        ),
        WEEKNUM ( [Date], 2 ) = VALUE ( RIGHT ( [ISO Week of ISO Year], 2 ) )
    ),
    [Date]-1
)

      Regards,

      Xiaoxin Sheng

      • jnrezk's avatar
        jnrezk
        Helper III
        5 years ago

        hmmm week 202127 should say July 11th its still off but its ok I can look for another solution