Forum Discussion
Helper ICustom Weeknum
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!
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 " & __customWeekNumBest Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
3 Replies
- amitchandak
Super User
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-Power-BI-Turning/ba-p/1187482You need to have additional condition for first week
v-jingzhangCommunity Support
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 " & __customWeekNumBest Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
NPCThis works. Thank you!
