How to Create Continuous Line Chart at End of Position

Hi Anonymous ,

You need create a  calendar table first. Create a relationship between actual table and calendar table depend on date.

Then create a measure like the following:

measure =
VAR _LASTDATE =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
VAR _LASTVALUE =
    CALCULATE (
        MAX ( 'Table'[Average Actual FTE] ),
        FILTER ( ALLSELECTED ( 'Table' ), [Date] = _LASTDATE )
    )
RETURN
    IF (
        ISBLANK ( MAX ( 'Table'[Average Actual FTE] ) ),
        IF ( MONTH ( MAX ( 'CALENDAR'[Date] ) ) >= MONTH ( _LASTDATE ), _LASTVALUE ),
        MAX ( 'Table'[Average Actual FTE] )
    )

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.