Forum Discussion

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

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
)