Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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.
the week number is coming from the data column "Overall changed on text"
Please refer to the following formula:
That week number is coming from the date
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
thank you!
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |