Week End date = 

'Calendar'[Date] + 7-1 * WEEKDAY( 'Calendar'[Date], 2 )