Forum Discussion
Burndown chart for software tasks
Hello, 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...
Hello,
thanks for the quick reply
Here is an example of something that is in a measure; same spirit:
VAR _Summarized = SUMMARIZE(
_History ,
'History'[id] ,
"@Last Date", MAX('History'[when] ) ,
"@Last Status" , CALCULATE(
MAX('History'[status]),
FILTER(
_History,
'History'[when]= MAX ('History'[when])
)
)
)
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
and then, count the IDs that match these criteria, and fill the New with this value in Burndown