Custom Weeknum

[NPC]

Hello,

I'm trying to create a column with custom week numbers (Operating periods) that end in the dates below:

1/1/2022 - 1/12/2022  - Week 1

1/13/2022 - 1/19/2022  - Week 2
1/20/2022 - 1/26/2022 - Week 3

Until the last week of the year. 

Any ideas on how I can accomplish this? I a pprecite your help!

[v-jingzhang · Accepted solution]

Hi @NPC 

Create a new column with below DAX

Column = 
var __days = DATEDIFF("2022-1-5",Dates[Date],DAY)
var __customWeekNum = IF(__days>0,ROUNDUP(__days/7,0),1)
return
"Week " & __customWeekNum

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[NPC]

This works. Thank you!

[amitchandak]

@NPC , You can get Thrusday to Wednesday week here

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

You need to have additional condition for first week