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.

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