Forum Discussion
Finding date using Weeknum Weekday and Year
Hi Team,
I have weeknumber column WeekDay Colum and Year column, I have to find date for this.
Can you please help me.
Thanks!
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.
3 Replies
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.
The8 ,
Your result is not correct sorry, 23/05/2023 was Tuesday and in result it is showing as Wednesday, which is not correct
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..