Week number must display 2 digits(e.g. 01 not 1 )

[MurVeman]

Hi All,

I wanted to see week number in two digits not in single digit(e.g. 01 not 1), please help me with fixing the below formula. Thanks in advance.

Dax Formula - 

Week_Number (Overall changed on timestamp) =
"CW " &
YEAR('TestEecution (2)'[Overall Changed On Text]) &
"-" &
WEEKNUM(
'TestEecution (2)'[Overall Changed On Text]
)

Current results for the above formula - 

Thanks & Regards,

Murali

[FREDPI]

You can also add a zero to the weeknumber and then take the right(2,weeknumber) in the formula.

This will give you the answer you are looking for.

[MurVeman]

the week number is coming from the data column "Overall changed on text"

[zenisekd]

Please refer to the following formula:

[MurVeman]

That week number is coming from the date

[zenisekd · Accepted solution]

Simply do this:
Week_Number (Overall changed on timestamp) =
"CW " &
YEAR('TestEecution (2)'[Overall Changed On Text]) &
"-" &
FORMAT(WEEKNUM(
'TestEecution (2)'[Overall Changed On Text]
),"00")

Kudos and mark as solution appreciated 

[MurVeman]

thank you!