Weeknum format customised

[Anonymous]

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.,?

[v-xiaotang · Accepted solution]

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.

[ghoshabhijeet]

@Anonymous  You can try this:

[Arul]

@Anonymous ,

try this one,

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

Thanks,

Arul

[speedramps]

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