ISO Year-Week pick up week numbers wrong

[maziiw]

I have a query which shows data per week.

IT shows 2024-53 week as ISO week, but 2024 should have 52 ISO weeks. According to the rules, if Thursday is in new Year, then ISO week should start from 1.

How can I fix this so that 30/12 and 31/12 goes to ISO week 1?

I am getting this:

[Rueen1941]

@italian brainrot clicker Good question, handling ISO weeks can be really tricky with year boundaries.

[Irwan · Accepted solution]

hello @maziiw 

try adding 21 in your weeknum DAX. as far as i know, 21 equal to ISOWEEKNUM in excel.

Week = WEEKNUM('Table'[Date],21)

Hope this will help.

Thank you.