Solved: Finding date using Weeknum Weekday and Year

Anonymous · ‎05-23-2023

Hi Team,

I have weeknumber column WeekDay Colum and Year column, I have to find date for this.

Can you please help me.

Thanks!

The8 · ‎05-24-2023

Hi,

I will try to explain you with example.
-Below is the table with weeknumber,week day and year

Use the below DAX formula to generate the date.

Date = DATE([Year], 1, 1) + ([Week Number] - 1) * 7 + SWITCH([Week Day], "Monday", 0, "Tuesday", 1, "Wednesday", 2, "Thursday", 3, "Friday", 4, "Saturday", 5, "Sunday", 6)

I hope it's clear now.

View solution in original post

Anonymous · ‎05-24-2023

@The8 ,

Your result is not correct sorry, 23/05/2023 was Tuesday and in result it is showing as Wednesday, which is not correct

The8 · ‎05-24-2023

Hi,
It depends on which date you are actually starting you week.
If you are starting your week on Sunday you have to modify the DAX formula as mentioning Sunday as 0 and if you arer starting you calander week on Monday then you can use the above mentioned DAX formula..

The8 · ‎05-24-2023

Hi,

I will try to explain you with example.
-Below is the table with weeknumber,week day and year

Use the below DAX formula to generate the date.

Date = DATE([Year], 1, 1) + ([Week Number] - 1) * 7 + SWITCH([Week Day], "Monday", 0, "Tuesday", 1, "Wednesday", 2, "Thursday", 3, "Friday", 4, "Saturday", 5, "Sunday", 6)

I hope it's clear now.