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.
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.