First date of the week from year and week number

[SJHA]

Hello,

I hope you can help me out. I've been searching and trying to find a way.

I have a column with "year" and one with "week number" - I need a column with the first day of week.

It seems so simple, but it bugs my mind.

Hope you can help,

Sandi

[Anonymous]

@amitchandak 

Could you help me? I don't get to finish

[amitchandak]

@SJHA , Try Monday Week start

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

//Sunday Week Start

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

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

[SJHA]

@amitchandak  Hello again

I ran into this problem:

The week 53 is causing a challenge. Do you know a quick fix to this logic?

[SJHA · Accepted solution]

@amitchandak 

It only accepts the caculated measures. I did check for data type to be Date/Time

[amitchandak]

@SJHA , you need to create that as new column. The name is yearnumber in your case

[SJHA]

@amitchandak  I changed the data type to whole numbers and somehow that works with the code you provided.

Thank you so much! You've made my day, if not a whole week!