Dax - Week number - first full week rather than 1st January

[e17aguilar]

Hello!

I've used CALENDARAUTO() in a new table and I've obtained a date column. Now, I'd like to calculate a new column with DAX to obtain the week number ( 1 - 54 ), but with the following conditions:
1) The first day of each week should be Saturday.
2) The first week of the year should be the first full week rather than the week which contains 1st January.

I've read similar posts and tried to apply and modify the DAX code to acheive that, but I haven't succeed.

Thanks in advance for your help. I really appreciate it.

Ernesto

[e17aguilar · Accepted solution]

I used the formulas exposed in these two posts:

Week number - first full week rather than 1st January?

Week commencing in DAX

The formula for this new column is:

Week_number = 1 + INT(DIVIDE((Calendar[Date].[Date] - WEEKDAY(Calendar[Date].[Date],16)+1) - (DATE(year(Calendar[Date].[Date]),1,1)),7))