Forum Discussion
Line Burn Up Chart Running Total 3 Date Column Count
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
1 Reply
- amitchandak
Super User
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=18180sRunning Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41
