Forum Discussion

maziiw's avatar
maziiw
Advocate I
1 year ago
Solved

ISO Year-Week pick up week numbers wrong

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:

 

Need Help
  • Irwan's avatar
    Irwan
    1 year ago

    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.

2 Replies

  • Irwan's avatar
    Irwan
    Super User
    1 year ago

    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.