Forum Discussion

AnnaML's avatar
AnnaML
Frequent Visitor
5 years ago
Solved

Week number not matching date

Hello,    I have an issue with week numbers. I have created a column called YearWeek using the following:  YearWeek = IF(WEEKNUM([Date].[Date])<10,FORMAT([Date],"YY0WW"),FORMAT([Date],"YYWW"))  ...
Need Help
Tips and Tricks
  • themistoklis's avatar
    themistoklis
    5 years ago

    AnnaML 

     

    Try this formula:

     

    YearWeek = RIGHT(IF(WEEKNUM('Calendar'[Date], 21)=53 && MONTH('Calendar'[Date])=1, YEAR('Calendar'[Date]) -1, YEAR('Calendar'[Date])),2) & WEEKNUM('Calendar'[Date], 21)

themistoklis's avatar
themistoklis
Community Champion
5 years ago

AnnaML 

 

If you want to use a Iso YEAR Week the formula should be like this:

YearWeek = IF(WEEKNUM('Calendar'[Date], 21)=53 && MONTH('Calendar'[Date])=1, YEAR('Calendar'[Date]) -1, YEAR('Calendar'[Date])) & "-" & WEEKNUM('Calendar'[Date], 21)

 

You need to put another parameter in weeknum function.... the parameter with value 21.

See also link below:

https://community.powerbi.com/t5/Desktop/Looking-for-real-year-week/m-p/1591530#M646306

 

 

AnnaML's avatar
AnnaML
Frequent Visitor
5 years ago

Hello, 

Thanks for your answere. It seems to work. Although is it possible to show YYWW instead of YYYY-WW? 

Kind Regards

  • themistoklis's avatar
    themistoklis
    Community Champion
    5 years ago

    AnnaML 

     

    Try this formula:

     

    YearWeek = RIGHT(IF(WEEKNUM('Calendar'[Date], 21)=53 && MONTH('Calendar'[Date])=1, YEAR('Calendar'[Date]) -1, YEAR('Calendar'[Date])),2) & WEEKNUM('Calendar'[Date], 21)

    • AnnaML's avatar
      AnnaML
      Frequent Visitor
      5 years ago

      Thanks for the support, it really helped!