Schedule Gantt Query - Matrix

Hi hackfifi ,

For this you need to have a calculation that checks if the start date is blank try the following code:

Schedule_Gant =
VAR _startdate =
    CALCULATE (
        MIN ( Schedule_Gant[Start_EOW] ),
        REMOVEFILTERS ( '_Calendar Schedule' )
    )
VAR _enddate =
    CALCULATE (
        MAX ( Schedule_Gant[Finish_EOW] ),
        REMOVEFILTERS ( '_Calendar Schedule' )
    )
VAR _period =
    MIN ( '_Calendar Schedule'[Weekly Cut-Off] ) >= _startdate
        && MAX ( '_Calendar Schedule'[Weekly Cut-Off] ) <= _enddate
VAR _finalPeriod =
    IF (
        _startdate = BLANK (),
        MAX ( '_Calendar Schedule'[Weekly Cut-Off] ) = _enddate,
        _period
    )
RETURN
    IF ( _finalperiod, 1 )

Be aware that this may need some changes because I have no data to test it out.