Forum Discussion

jfernand's avatar
jfernand
Frequent Visitor
9 years ago
Solved

Converting date into YYYYWW

Hi team,   I have a date in the 2017-01-01 format. I wanted to convert it into 201701 (week number 1 of the year 2017) I have used the formula Week Number = YEAR( Calendar(date) ) & WEEK( Cal...
Need Help
  • Chihiro's avatar
    Chihiro
    9 years ago

    I'd do it in this manner.

     

    Week Number =
INT (
    CONCATENATE (
        YEAR ( 'Calendar'[Date] ),
        FORMAT ( WEEKNUM ('Calendar'[Date] ), "00" ) 
        ) 
    )
Chihiro's avatar
Chihiro
Solution Sage
9 years ago

I'd do it in this manner.

 

Week Number =
INT (
    CONCATENATE (
        YEAR ( 'Calendar'[Date] ),
        FORMAT ( WEEKNUM ('Calendar'[Date] ), "00" ) 
    ) 
)
jfernand's avatar
jfernand
Frequent Visitor
9 years ago

wow, apparently there were tons of options for this scenario. Thank you everyone for your help. This option ended up being the most complete and yet simple