Calculating Week Start Date from Week Number

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.