Burn-Up Chart for Project % Completion

Hi brianlehr 

1.Create a date table

Date table = CALENDARAUTO()

Create relationship as below

2. in Sheet3, create measures as below

lastdate = MAXX(FILTER(ALL(Sheet3),[% Completed]<>BLANK()),Sheet3[Date])

desireddate = DATE(2019,6,30)

period = DATEDIFF([lastdate]+1,[desireddate],DAY)/2

last percent = 
CALCULATE([% Completed],FILTER(ALL(Sheet3),Sheet3[Date]=[lastdate]))

rate = (1-[last percent])/[period]

start = IF(MAX('Date table'[Date])=[lastdate]+2,[last percent]+[rate])

data_modified =
VAR num =
    DATEDIFF ( [lastdate] + 2, MAX ( 'Date table'[Date] ), DAY ) / 2
RETURN
    IF (
        num = INT ( num )
            && MAX ( 'Date table'[Date] ) <= [desireddate],
        IF ( MAX ( 'Date table'[Date] ) = [lastdate] + 2, [start], [rate] ),
        BLANK ()
    )

% Desired =
VAR desireddata =
    SUMX (
        FILTER (
            ALL ( 'Date table' ),
            'Date table'[Date] >= [lastdate] + 2
                && 'Date table'[Date] <= [desireddate]
                && 'Date table'[Date]
                    <= MAX ( 'Date table'[Date] ) + 1
        ),
        [data_modified]
    )
RETURN
    IF ( [data_modified] <> BLANK (), desireddata, BLANK () )

final = IF([% Desired]=BLANK(),[% Completed],[% Desired])

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.