DAX - Week Number - to start from 1st Jan

[ElMeSaFeR]

Hello!

I've used CALENDAR() in a new table and I've obtained a date column, I'd like to calculate a new column with DAX to obtain the week number ( 1 - 54 ), but with the following condition:

1) The first week of the year should be the 1st January for every year.

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

[tackytechtom · Accepted solution]

Hi @ElMeSaFeR ,

How about this:

Here the DAX that was used to create the calculated column:

WeekNumber = 
ROUNDDOWN (
    ( ( RANKX ( 
        FILTER ( 
            'date', 
            'date'[Year] = EARLIER ( 'date'[Year] )
        ),
        'date'[Dates],
        , ASC
        , DENSE
    ) + 6 ) ) / 7, 0 )

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[ElMeSaFeR]

Excellent, Thanks alot 🙂