Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Week number by year

Hi!  I have a chart showing trend by week number. However when 2020 began my week 1 is placed at the start of my chart and not as sequal to week 52/53. I've tried making a "week + year" column bu...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey Anonymous 

     

    Just create an additional calculated column that contains an integer value like so

    yearweekno = year('<tablename>'[date]) * 100 + weeknum('<tablename>'[date])

    Then you can use this column to sort your column that contains these values

    week 51 (2019)    week 52 (2019)    week 1(2020)   week 2 (2020)

    This explains the feature "Sort by column": https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

    The same article also explains how the sort order can be adjusted in visuals.

     

    Hopefully this provides what you are looking for.

     

    Regards,

    Tom

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous the DAX syntax you need to use is weeknum.

 

I personally use datediff and specify the split by days, but from what you are saying you want weeknum. 

 

Let me know if that helps, or please explain again.