WEEKNUM (for the beginning of the year)

[Pikachu-Power]

Hello,

WEEKNUM(Calender[Date], 2) gives for the CW1 the dates 01.01. / 02.01. / 03.01. But actually these dates belongs to CW53. CW1 should start at 04.01.

What is the reason for that? The other functions in Power BI respect that fact. And is that adjustable?

thanks.

[themistoklis · Accepted solution]

@Pikachu-Power 

Change the formula to the following one:

WEEKNUM('Calendar'[Date], 21)

Instead of 2 use 21. Although 21 is not available in the documentation, it is a valid parameter in formula

[Pikachu-Power]

hi themistoklis,

yes thats work. but in combination with the year i get following problem:

normally the CW53 should belong the year 2020. Something like YEAR(calender(date), 21) would be nice 🙂

for my x-axis i use:

YEAR_CW = IF(WEEKNUM(Calender[Date],21) < 10, YEAR(Calender[Date])&"_"&0&WEEKNUM(Calender[Date],21), YEAR(Calender[Date])&"_"&WEEKNUM(Calender[Date],21))

so I get the shift describeb above. some ideas to get rid of this problem?

[Pikachu-Power]

Here is a solution from 2016:

Solved: Need help creating week number - Microsoft Power BI Community

Is it still current?

[themistoklis]

@Pikachu-Power 

I think this formula may help you.

Year = IF(WEEKNUM('Calendar'[Date], 21)=53, YEAR('Calendar'[Date]) - 1, YEAR('Calendar'[Date]))