Forum Discussion
Solved
Week number with 2 digits
Hi, The weeknum formula returns the weeks 1 to 9 as single digits. Is there a way to display these as 2 digits, e.g. 01, 02....09? Thanks!
Looks like I've managed to solve this myself :smileyhappy:
I used the DAX Formula " weeknumber = FORMAT(WEEKNUM([date],1),"00") "
If anyone has any other better solutions, please feel free to contribute.
Looks like I've managed to solve this myself :smileyhappy:
I used the DAX Formula " weeknumber = FORMAT(WEEKNUM([date],1),"00") "
If anyone has any other better solutions, please feel free to contribute.
You could go with additional custom column (based on your formula):
date = FORMAT(DATE(LEFT([Year-Month],4),RIGHT([Year-Month],2),1),"yyyy-mm")