Calculating Week Start Date from Week Number

[DevadathanK]

Hi Community!

<Message deleted>

Thanks for any help!

[v-juanli-msft · Accepted solution]

Hi @DevadathanK 

1.

Transform data;

select "Year" and "WeekNumber", select Remove rows->Remove duplicates;

close&&apply

2.

create a date table

date =
VAR minyear =
    MIN ( 'Table'[Year] )
VAR maxyear =
    MAX ( 'Table'[Year] )
VAR datetable =
    CALENDAR (
        DATE ( minyear, 1, 1 ),
        DATE ( maxyear, 12, 31 )
    )
RETURN
    ADDCOLUMNS (
        datetable,
        "year", YEAR ( [Date] ),
        "month", MONTH ( [Date] ),
        "week", WEEKNUM ( [Date] ),
        "year-week", FORMAT (
            [Date],
            "yyyy-ww"
        ),
        "weekday", WEEKDAY (
            [Date],
            2
        )
    )

3.

Create a calculated column in main table

year-week = [Year]&"-"&[Weeknumber]

4. 

create a relationship between two tables based on "year-weeknumber".

5. create calculated columns in main table

weekstart = CALCULATE(MIN('date'[Date]),ALLEXCEPT('Table','Table'[year-week]))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@DevadathanK 

This was done using YYYYWW or YYYY-WW

Weektodate = date(RIGHT(Table[Week Format],4),1,1)+(mid(Table[Week Format],5,SEARCH(" ",Table[Week Format])-5 )*7) - (WEEKDAY(date(RIGHT(Table[Week Format],4),1,1)))

Give some sample data

[DevadathanK]

Hi

I have 2 columns, one for the WeekNumber and another for the Year. 

<Message deleted>