Forum Discussion

afk's avatar
afk
Advocate II
8 years ago
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!
Need Help
  • afk's avatar
    afk
    8 years ago

    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.

afk's avatar
afk
Advocate II
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If your week numbers are stored as whole numbers, then:

format(if(WEEKNUM([date]<10,CONCATENATE(0,WEEKNUM([date]),WEEKNUM([date]),00)

 

that is,

 

format (<value>, <format_string>) where  

<value> = if(WEEKNUM([date]<10,CONCATENATE(0,WEEKNUM([date]),WEEKNUM([date]) 

and

<format_string> = 00

afk wrote:

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.