Weeknum not filtering correctly with Year

[WxShady13]

I sort my data by WeekNum (51,52,53,2) however with the New Year it is not working. I have created a concatenated column Year/Weeknum(202052,20212) but it still does not sort right. It shows blank weeks that would not exist (202060). How do I continue to display by Week # but keep it so it flows into the proper order based on Year?

 

[Toadstool]

Hi WxShady13,

At the beginning of the year the week will be a single digit so you would need to put a leading zero, e.g.

Book2
	E	F	G	H	I
1	Date		Weeknum		Concat
2	12/20/2021		52		202152
3	12/27/2021		53		202153
4	1/3/2022		2		202202
5	1/10/2022		3		202203
6	1/17/2022		4		202204
Sheet1

Cell Formulas
Range	Formula
G2:G6	G2	=WEEKNUM(E2)
I2:I6	I2	=YEAR(E2)&TEXT(WEEKNUM(E2),"00")

 

[WxShady13]

Thank you for the quick response. My formulas are in Power BI and I have the Weeknum pulled like you show. The change I have for the Concat column is below.
I formatted the WeekYearCombo column as Whole Number but it still does not work. What am I doing wrong?

WeekYearCombo = Year(Table1[Date]) & FORMAT(WEEKNUM(Table1[Date],1),"00")

 

[sandy666]

update your profile about Excel version, OS and Power Tools
in the first post, mention what you are using because as you can see it's not that obvious

 

[WxShady13]

I am confused because I posted in a Power BI forum?

 

[sandy666]

Sometimes people posting here by mistake so will be better if you do that - less troubles and wasted posts

 

[WxShady13]

Thank you for the information, I will update immediately

 

[sandy666]

thanks for that
have a nice day