How to build a cumulative graph

Good Morning, 
do You have a DateTable ? 
if not you can create one by using this code:

DIM_Datetable =
VAR calender =

CALENDAR(
Date( 2020,01,01 -- FirstDate
),
DATE(
2030,01,01 -- Last Date
)
)

RETURN

ADDCOLUMNS(
calender,
Year,YEAR([Date]),
Quarter, CONCATENATE(Q,QUARTER([Date])),
Year Month, YEAR([Date]) & - & FORMAT(MONTH([Date]), 00),
Month, MONTH([Date]),
Month Name, FORMAT([Date], MMMM),
Day of year, DATEDIFF(DATE(YEAR([Date]),1,1),[Date],DAY)+1,
Day of Month, DAY([Date]),
Day of week, WEEKDAY([Date],2),
Day Name, FORMAT([Date], DDDD),
Weeknum, FORMAT(WEEKNUM([Date],2),00),
Year Weeknum, YEAR([Date]) & FORMAT(WEEKNUM([Date],2),00),
Year Quarter, YEAR([Date]) & - & QUARTER([Date])
)

This code will create a date table including the dates you specify. After creating this table You can connect it with your fact table by a one to many relationship then use the date table instead of your date column in your graph.

Let me know if this was useful!

Hi game1 

There are two possibilities. The first one will require a date table as DAX_Machine  suggested. When the data model is set up correctly you can use the Date from the Date table in the visual and then add this measure

RunningTotal =
VAR MaxDate =
    MAX ( DIM_Date[Date] )
RETURN
    CALCULATE (
        COUNTROWS(Table),
        KEEPFILTERS ( 'Table'[Date] <= MaxDate
            && 'Table'[Date] >= MaxDate,
        ALL ( DIM_Date )

If a Date table isn't an option you can try Greg_Deckler solution

The Case for No CALCULATE (linkedin.com)

RunningTotal =
VAR __Date = MAX('Table'[Date])
VAR __Table = FILTER(ALLSELECTED('Table'),[Date] <= __Date)
VAR __Result = COUNTX(__Table,[Items])
RETURN
    __Result   

Hope this helps

Joe

If you found my answer helpful and it solved your issue, please accept as solution