Forum Discussion
Week Start Date
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.
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)+1Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
2 Replies
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)+1Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482Thanks a lot Amit. This worked.
