Forum Discussion
Help with burndown charts from VSTS data
Can someone please help me find a solution. Nothing I see on these blogs will work. I have historical data from VSTS and need to create a burndown chart. This is Remaining work aggregated by Changed Date and with the Is Current flag. Please help. o Calender DIM.
no that does not work because there is no cummulative total just the remaining work at any one point in time. Not a real burndown.
I got it to work with the following steps provided as guidance from a friend.
Step 1: Took the history table and subtracted the “Is Current Values” between True and False records.
TrueFalseDiff =
var remtru =
CALCULATE('Work Items - Last 26 Weeks history'[Total Remaining],'Work Items - Last 26 Weeks history'[Is Current] = TRUE)
var remfls =
CALCULATE('Work Items - Last 26 Weeks history'[Total Remaining],'Work Items - Last 26 Weeks history'[Is Current] = FALSE)
return (remfls-remtru)
Step 2: Created cumulative total followed by subtracting the true false diff:
Cumulativetot =
var runtot = CALCULATE (
SUM ( 'Work Items - Last 26 Weeks history'[Remaining Work] ),
FILTER (
ALL ( 'Work Items - Last 26 Weeks history'[Changed Date] ),
'Work Items - Last 26 Weeks history'[Changed Date] <= Max('Work Items - Last 26 Weeks history'[Changed Date] )))
return (runtot-[TrueFalseDiff])
Finally I took the categorical line chart and extended the date to the end of my pseudo sprint:
And wahla.
8 Replies
quentin_vigneSolution Sage
Hi Anonymous
Could you please provide us a sample of your data (with tablename) as a table or a text so we can copy / paste that ?
And please post us expected result
More information on how to get your question answered and how to post datas : https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Using the Work Items - 26 weeks with History table . You can see the burndown measures I have writen that do not work.
- quentin_vigne
Anonymous
I can't download your file, don't know why
- Quentin
arsaveliHelper I
Hi!
Looks like you are trying to create manual burndown DAX calculation. Since you are querying WorkItemSnapshot, it already has "Remaining Work" column - you can simply plot that by date and get basic burndown, without any DAX.
no that does not work because there is no cummulative total just the remaining work at any one point in time. Not a real burndown.
I got it to work with the following steps provided as guidance from a friend.
Step 1: Took the history table and subtracted the “Is Current Values” between True and False records.
TrueFalseDiff =
var remtru =
CALCULATE('Work Items - Last 26 Weeks history'[Total Remaining],'Work Items - Last 26 Weeks history'[Is Current] = TRUE)
var remfls =
CALCULATE('Work Items - Last 26 Weeks history'[Total Remaining],'Work Items - Last 26 Weeks history'[Is Current] = FALSE)
return (remfls-remtru)
Step 2: Created cumulative total followed by subtracting the true false diff:
Cumulativetot =
var runtot = CALCULATE (
SUM ( 'Work Items - Last 26 Weeks history'[Remaining Work] ),
FILTER (
ALL ( 'Work Items - Last 26 Weeks history'[Changed Date] ),
'Work Items - Last 26 Weeks history'[Changed Date] <= Max('Work Items - Last 26 Weeks history'[Changed Date] )))
return (runtot-[TrueFalseDiff])
Finally I took the categorical line chart and extended the date to the end of my pseudo sprint:
And wahla.Hi Anonymous, you forgot to mention where you got [Total Remaining] from...I'm guessing it is also calculated...
