topic Help Please with calculate cumulative line in DAX Commands and Tips

Help Please with calculate cumulative line

AShabana — Mon, 07 Nov 2022 06:34:30 GMT

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)

Re: Help Please with calculate cumulative line

AShabana — Mon, 07 Nov 2022 06:14:17 GMT

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

Re: Help Please with calculate cumulative line

wdx223_Daniel — Mon, 07 Nov 2022 07:55:42 GMT

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

Re: Help Please with calculate cumulative line

v-easonf-msft — Mon, 14 Nov 2022 09:49:47 GMT

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