Forum Discussion
WeekNum sequence issue
Hi there, I created a Date table as following: The weekNumber dax is: WeekNum = "Wk" & WEEKNUM('Date'[Date]) However, the weekNumber does not work well in chart sequence. The ac...
Hi Anonymous ,
you need two columns, one with the week as an int, the other as the week as a string, then you will sort the week as a string by the week as int. see image below
richbenmintz
Resident Rockstar
Resident RockstarHi Anonymous ,
you need two columns, one with the week as an int, the other as the week as a string, then you will sort the week as a string by the week as int. see image below
Got it! Thank you!!