topic Re: First date of the week from year and week number in DAX Commands and Tips

First date of the week from year and week number

SJHA — Tue, 01 Sep 2020 13:01:59 GMT

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

amitchandak — Tue, 01 Sep 2020 13:09:33 GMT

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

SJHA — Tue, 01 Sep 2020 13:24:30 GMT

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

amitchandak — Tue, 01 Sep 2020 13:46:39 GMT

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

SJHA — Tue, 01 Sep 2020 13:55:30 GMT

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!

Anonymous — Wed, 21 Oct 2020 13:54:03 GMT

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

SJHA — Mon, 07 Dec 2020 09:40:15 GMT

amitchandak Hello again

I ran into this problem:

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