Forum Discussion
DAX - Week End Date
Hi All, I am creating a date table and I would like a column for the end of week (sunday) for each week. I've tried; "Week End Date", [Date] - WEEKDAY([Date],2)+7, But you can see it isn't work...
Anonymous , weekend
Sunday
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Saturday
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],1)
for all other week day, refer to my blog and files
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
Thank you for this, I search everywhere. This is so simple and works great!