what should be my Return value? for DAX weeknum

[Anonymous]

 I am using the power bi desktop, i have a data set from the USA, where my order date starts with 2 July 2021, so I need to figure out the sale amount for the first week, the second week, and so on, so for week num I have used the DAX function but I am not able to figure out what should be return value should be? oh 2 july 2021 ,week starts on Thursday so should I go for return value 14 or is it something else I should know. pls help!!!

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[Fowmy]

@Anonymous 

If you need to add a column where your week number within the year starts from Thursday then

=WEEKNUM([Date],14)

[Anonymous]

ok does it have anything to do with ISO calender , because whether ISO i.e 21 returns the week of the month greater than 5. since ISO has 5 weeks in a month.

i have used 21 as the return value for ISO but I still get week number 6 for certain entries 30 and 31 aug

[Fowmy]

@Anonymous 

Please refer to this article: https://dax.guide/weeknum/