Get saturday of the week from weeknumber

[Anonymous]

Team,

I have a fisweek column and the data looks something like this 2020406,2020407, etc year & week now I need to create a date column which gives saturday date of the week based on the week number.

Thanks!

Raki

[dk_dk · Accepted solution]

Hi @Anonymous ,

Assuming your input data is 8-character long text in yyyymmdd format, you can use this DAX calculation in a calculated column, to calculate the saturday date of the given week. It does not even need the week number 😉

saturdayofweek = 

VAR _year = LEFT(dates[date],4)
VAR _month =LEFT(RIGHT(dates[date],4),2)
VAR _day = RIGHT(dates[date],2)
VAR fulldate = DATE(_year,_month,_day)

VAR dayofweek = WEEKDAY(fulldate)
VAR diff_to_sat= 6-dayofweek

VAR sat_of_week = fulldate + diff_to_sat

RETURN
sat_of_week

If your input data is in a different format you might need to tweak the _year, _month and _day cariables to extract the year, month and day, to construct the date in date format correctly. If your data is in date format already, you can also just use a direct column reference to your date column instead of the fulldate variable, and it should work (then you can remove the other vars before that).

Let me know if you have any questions.