Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AShabana
Frequent Visitor

Help Please with calculate cumulative line

AShabana_0-1667801374506.png

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)

 

3 REPLIES 3
wdx223_Daniel
Super User
Super User

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

AShabana
Frequent Visitor

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.