Forum Discussion

NPC's avatar
NPC
Icon for Helper I rankHelper I
4 years ago
Solved

Custom 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/2...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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's avatar
    NPC
    Icon for Helper I rankHelper I
    4 years ago

    This works. Thank you!