Forum Discussion

decarsul's avatar
decarsul
Helper V
5 years ago

Weeknum wrong

Gday all,   As some / most here have already stated / noticed, for us europeans (according to iso 8601) the weeknumber for 2021 is wrongly calculated. In fact, the thing that worries me more is tha...
Help appreciated
decarsul's avatar
decarsul
Helper V
5 years ago

Not entirely sure what to do or how to interpret your answer.

It is DAX code messing up in my opinion, as you stated, its starting a new week with a new year. Regardless the fact that you state a week should start on sunday or monday. What is the point of that argument then in this case?

amitchandak's avatar
amitchandak
Super User
5 years ago

decarsul , You can log an issue or Idea

Issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

Idea - https://ideas.powerbi.com/ideas/

 

As of  now, you can create your own column

 

//Monday Week start

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

 

//Sunday Week Start

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],1)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],1)

 

min week start of year = minx(filter('Date',year([Week Start date])=earlier(year(Week Start date]))),[Week Start date])
week No = quotient(datediff([min week start of year],[date],day),7)+1