Forum Discussion

Helper I

5 years ago

Solved

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 ...

Need Help

amitchandak
5 years ago
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-Power-BI-Turning/ba-p/1187482