Weeknum format customised

[abhishek_2593]

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 @abhishek_2593 

"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]

@abhishek_2593  You can try this:

[Arul]

@abhishek_2593 ,

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