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...
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.
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.