Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Weeknum format customised

Is there a way to customise the Weeknum to display the Month name and then the week number(MM/Weeknum) rather than the continuous week number from 1 - 53?

Ex - Jan - 01, Jan - 02 etc.,?

Need Help
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    "to display the Month name and then the week number(MM/Weeknum) rather than the continuous week number from 1 - 53", in this scenario, you can try this, create the column below

     

    Custom MMWeek = 
var _days= CALCULATE(COUNTROWS('Calendar'),FILTER(ALL('Calendar'), 'Calendar'[Year]=EARLIER('Calendar'[Year]) && 'Calendar'[Month]=EARLIER('Calendar'[Month]) && 'Calendar'[Date]<=EARLIER('Calendar'[Date])))
var _customWeek=ROUNDDOWN( DIVIDE(_days-1,7),0)+1
return FORMAT('Calendar'[Date],"mmm")&"-"&_customWeek

     

    result

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • speedramps's avatar
    speedramps
    Super User
    4 years ago

    It is best practice to use a Calendar table. Dont attempt to create your own DAX date logic.
    Create a Calendar once with a date and MM/Weeknum column and use it always.

    see https://youtu.be/BtYn1hfdSAM

     

     

     

  • Arul's avatar
    Arul
    Super User
    4 years ago

    Anonymous ,

     

    try this one,

    Monthweek = FORMAT(financials[Date],"MMM")&"-"&FORMAT(financials[Date],"ww")

    Thanks,

    Arul

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    "to display the Month name and then the week number(MM/Weeknum) rather than the continuous week number from 1 - 53", in this scenario, you can try this, create the column below

     

    Custom MMWeek = 
var _days= CALCULATE(COUNTROWS('Calendar'),FILTER(ALL('Calendar'), 'Calendar'[Year]=EARLIER('Calendar'[Year]) && 'Calendar'[Month]=EARLIER('Calendar'[Month]) && 'Calendar'[Date]<=EARLIER('Calendar'[Date])))
var _customWeek=ROUNDDOWN( DIVIDE(_days-1,7),0)+1
return FORMAT('Calendar'[Date],"mmm")&"-"&_customWeek

     

    result

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.