Finding date using Weeknum Weekday and Year

[Anonymous]

Hi Team,

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

Can you please help me.

Thanks!

[Anonymous]

@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]

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 · Accepted solution]

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.