Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power BI Week Number and Year

Hi, I am trying to produce a new column which converts a date field to a week number and year. I have the following DAX formula:   WEEK: WEEKNUM('Overbooking'[DATE]),    The DATE is in the follow...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    As parry2k suggested, you could simply use FORMAT() function. 

     

    And if you want to calculate week started on Monday instead of Sunday, you could use the following formula:

     

    Column = WEEKNUM([Date],2) &"-"&YEAR([Date])

     

     

    Please take a look at the differences between these two method:

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

As parry2k suggested, you could simply use FORMAT() function. 

 

And if you want to calculate week started on Monday instead of Sunday, you could use the following formula:

 

Column = WEEKNUM([Date],2) &"-"&YEAR([Date])

 

 

Please take a look at the differences between these two method:

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.