Line Burn Up Chart Running Total 3 Date Column Count

[DBKAHUNA88]

Hello,

I have 3 date columns in my excel database. Issue Created Date, Issue Containment Date, Issue Corrected Date.

I want to create a burn up line chart showing the count over time of each of these date sets. 

I don't want them to reset at a year/month/day field i want them to rise forever.

I've tried the running total quick measure on the dates themselves but this doesn't change anything. 

I've tried creating a 1 and 0 IF column in the excel data to create a running total but this also doesn't work in powerBI

Apologies I'm very new to power BI and am using this forumn to learn and develop.

Below is the excel equivalent

[amitchandak]

@DBKAHUNA88 , first of all you have join all these dates with one date table and have this date range column there, I think week's start and end date

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

Week name = [Week Start date] & " -  "& [Week End date]

Only one join will be active. So create measure using userelationship for inactive join

M1= calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date]))

First create measure then create cumm on these meausres

example

Cumm Sales = CALCULATE([M1],filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cumm Sales = CALCULATE([M1],filter(allselected(date),date[date] <=max(date[Date])))

You can also consider window function

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s
Power BI Date Table: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=18180s

Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41