Help Please with calculate cumulative line

[AShabana]

as shown on the screenshot I want the drawn cumulative line to be connected continuously even if the source data table for some fields does not have the data for specific date. (27-June-2022 & 9-Aug-2022 for example)

[wdx223_Daniel]

guess "lastdateevc" may give a blank value in those dates

[AShabana]

also The IPC Cumm values the values is not connected to each other by the line !! could any one help

[v-easonf-msft]

Hi， @AShabana 

I think the following part should be enough, no need to judge with an if statement, it will break the continuity of the visual.

EVCDis Cum. =
CALCULATE (
    SUM ( EVCDis[EVCDis] ),
    FILTER ( ALL ( DatesID ), DatesID[DatesID] <= MAX ( DatesID[DatesID] ) )
)

Best Regards,
Community Support Team _ Eason