Recreating following Excel visual on Power Bi?

[powerbinoobster]

So I have the following Visual in Excel that I want to create on Power Bi.

Cumulative Created (Yellow Line Value): start at 949 from 2021, then adds each month "Created" to the new sum(Running total). For example 949 + 49 = 998, etc.. On my Power Bi visual, this is the "Originated" bar

Cumulative Approved (Green Line Value): start at 852 from 2021, then add each month "Approved" to new sum. For example 852 + 9 = 861. On my Power Bi visual, this is the "Completed" bar.

Each line starts at the corresponding y-axis value.

How would I create these two measure, plot the line graphs in my Power Bi Visual, and create the same visual? I already have the Clusters bars at the bottom. I attached my Power Bi file with what I have so far.

Power Bi file:

https://drive.google.com/file/d/1qbYbYzGkEHsVc78_-k1A-078Mh9bl3Dw/view?usp=share_link

[Ashish_Mathur]

Hi,

There is a problem with downloading the file.  The site is reported as unafe by MS Edge.  Please share another download link.  Also, how did you derive the numbers in the Backlog column?

[powerbinoobster]

Added a new link! Please take a look. 

Also for Backlog column, I do not need

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[FreemanZ]

You would need a Date table for cumulative aggregations. With a Date table, there are many YTD-relevant functions like TOTALYTD.

If not, you at least need a MonthNumber column, so the comparison could be made to ensure all months smaller will be aggregated. 

The code is like this

CumulativeCreated = 

CALCULATE(

    SUM(Data[Created]),

    FILTER( ALL(Data[MonthNumber]),  Data[MonthNumber]<=EARLIER(Data[MonthNumber])

    )

)

[ppm1]

You could make the chart with the Deneb visual, by layering 6 "mark"s (4 lines and 2 bars).

Getting Started | Deneb

Pat