Hi Chris. Yes it works, but had to take the keydate out of the main query as that is part of the:

LEFT JOIN BI1_DW_Dim_CalendarDefinition PlannedRelease (NOLOCK)

on PlannedRelease.keydate = KeyDatePlannedRelease

in there will be the field called KeyDate

it will be PlannedRelease.keydate

But your chances are amazing!!!