Calculate Question - How To Keep A Column Value In The Calculation

Hi danielpaduck ,

Please try below dax formula:

Labor Hours Conditional (D) = 
VAR minPeriod = MIN(CFGDates_Min_Max[Min Period (msr)])
VAR maxPeriod = MAX(CFGDates_Min_Max[Max Period (msr)])
RETURN
SUMX(
    'LD Actual',
    IF(
        'LD Actual'[Period] = minPeriod,
        'LD Actual'[Hours (Actual)],
        IF(
            'LD Actual'[Period] > minPeriod && 'LD Actual'[Period] <= maxPeriod,
            CALCULATE(
                SUM('LD Forecast'[Hours (Forecast)]),
                'LD Forecast'[Period] = 'LD Actual'[Period]
            ),
            BLANK()
        )
    )
)

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.