SQL statement. I want to create the date for the start of the weak in SQl from date and week number

[Anonymous]

HI,

I am trying to use SQL statement for one of my visuals. I want to create week start date from week no and date. I am posting my query please check where is the problem. it is showing wrong results. 

as you see in the date column, the day is 31 jan and week 4 and the start date should be 25 January.  but it is not showing the correct results. 

please help in this regard. thank you.

@Greg_Deckler @amitchandak @Fowmy @Jihwan_Kim 

[amitchandak]

@Anonymous , Try like

Week to Date = var _st = date([year],1,1)
var _week = [week]
Return _st+((_week-1)*7) -WEEKDAY(_st,2)+1

discussed in

https://amitchandak.medium.com/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3