WeekNumber In a Month

[DanielDArtist]

Hi All,

I have the following business case, please help me to solve it.

I would like to create a dimension (x axis for example in a line chart) and show each weeknumber inside the month.

Number of the weeks should have to restart in every month.

I have a date field like 2017.01.02 (YYYY.MM.DD)

I would like to get, for example 201701W1  201701W2 201701W3 .... 201702W1 ...201702W4.....201703W1.

Thanks,

Daniel

[Anonymous · Accepted solution]

Hi @DanielDArtist,

You can try to use below formula to show the formatted date.

Calculate column:

Week = FORMAT([Date],"yyyymm")&"W"&WEEKNUM([date],1)-WEEKNUM(DATE([date].[Year],[date].[MonthNo],1),1)+1

Regards,

Xiaoxin Sheng

[Anonymous]

The DAX formula you need is: Year([Date])&FORMAT([Date],"MM")&WEEKNUM([Date],2)