Week Start Date

[snemilipuri]

 Hi,

A column has been created for week start date (Tuesday). But getting a problem at the end of 2020 and starting of 2021.

In the below images, Dec 29, 2020 to Jan 4, 2021 is being considered as week 53, 2020. Whereas Jan 5, 2021 is being considered as week 2, 2021. 

But seems week 1, 2021 is merged with week 53, 2020. 

Please help to start the week of 2021 with week 1, 2021 (from Jan 5, 2021) instead of week 2, 2021. 

[amitchandak · Accepted solution]

@snemilipuri , Try column like

Week Start Year = year([Week Start date])

min week start of year = minx(filter('Date',year([Week Start date])=earlier(year(Week Start date]))),[Week Start date])

or

min week start of year = minx(filter('Date',([Week Start Year ])=earlier((Week Start Year ]))),[Week Start date])

week No = quotient(datediff([min week start of year],[date],day),7)+1

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

[snemilipuri]

Thanks a lot Amit. This worked.