Burndown chart for software tasks

Question

Hello,&nbsp;I'm trying to create a table containing data that will be used to create a burndown chart. As an inputs, I have two tables:1. Dates: the table date corresponding to the list of dates for a given release/sprint2. History: the table containing the transitions for the set of tasks to be performed&nbsp; &nbsp; &nbsp; &nbsp;The fields are:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id: id of the task&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; when: transition date between to states&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; status: status of a task (New, Assigned, Analyzed, Solving, etc)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; It looks like this:id when state12/1/2024New12/2/2024Assigned23/1/2024New32/2/2024Solving24/1/2024Solving&nbsp;I'm trying to build a Burndown table from these datas using DAX. I don't want a measure here.DateNewAssignedAnalyzed1/1/20241&nbsp;&nbsp;2/1/202421&nbsp;3/1/20241114/1/20240&nbsp;&nbsp;5/1/2024...&nbsp;&nbsp;&nbsp;New = number of tickets with last 'when' is "New" before the date.I've been circling around a solution without converging for quite a some time, hence a little help would be highly appreciated.&nbsp;Thanks in advance for any advice you may give!

govindarajan_d · Answer

Hi&nbsp;Dni&nbsp;,&nbsp;New = number of tickets with last 'when' is "New" before the date. I am not able to understand this. Can you help us by posting a single calculation and how it is done?

dni · Answer

Hello,thanks for the quick reply&nbsp;Here is an example of something that is in a measure; same spirit:&nbsp; &nbsp; VAR _Summarized = SUMMARIZE( &nbsp; &nbsp; &nbsp; &nbsp; _History&nbsp;, &nbsp; &nbsp; &nbsp; &nbsp; 'History'[id] ,&nbsp; &nbsp; &nbsp; &nbsp; "@Last Date", MAX('History'[when] ) , &nbsp; &nbsp; &nbsp; &nbsp; "@Last Status" , CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX('History'[status]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; _History,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'History'[when]= MAX ('History'[when])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ) &nbsp; &nbsp;Basically for each date in the calculated table I want to:- Filter History to get only the dates before the reference date(e.g. the first date in the Burndown table is 1/1/24. This is the reference date)- Filter History to get the latest [when] for each id(e.g if I have a when for id1 at 31/12/23 and 30/12/23, I'll keep only the 31/12/23 one)- and Finally filter history to get the id in status New&nbsp;and then, count the IDs that match these criteria, and fill the New with this value in Burndown

dni · Answer

Hello,thanks for the quick reply&nbsp;Here is an example of something that is in a measure; same spirit:&nbsp; &nbsp;&nbsp;VAR&nbsp;_Summarized&nbsp;=&nbsp;SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;_History&nbsp;,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'History'[id]&nbsp;,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"@Last Date",&nbsp;MAX('History'[when]&nbsp;) ,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"@Last Status"&nbsp;,&nbsp;CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MAX('History'[status]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;_History,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'History'[when]=&nbsp;MAX&nbsp;('History'[when])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ) &nbsp;&nbsp;Basically for each date in the calculated table I want to:- Filter History to get only the dates before the reference date(e.g. the first date in the Burndown table is 1/1/24. This is the reference date)- Filter History to get the latest [when] for each id(e.g if I have a when for id1 at 31/12/23 and 30/12/23, I'll keep only the 31/12/23 one)- and Finally filter history to get the id in status New&nbsp;and then, count the IDs that match these criteria, and fill the New with this value in Burndown

Forum Discussion

Burndown chart for software tasks

3 Replies

Related content

Burndown Chart

PowerBI: Create Burndown Chart

Burndown chart

Burndown chart for data progress

Gantt Chart by MAQ Software

1	2/1/2024	New
1	2/2/2024	Assigned
2	3/1/2024	New
3	2/2/2024	Solving
2	4/1/2024	Solving

Date	New	Assigned	Analyzed
1/1/2024	1
2/1/2024	2	1
3/1/2024	1	1	1
4/1/2024	0
5/1/2024	...