Forum Discussion
Running Total Burndown
Hi folks, I am in need of help with a DAX problem I have been experiencing for over a week. Problem Statement I want to create a power-bi line-chart that is: A cumulative total, month-over-mon...
manikumar34
Solution Sage
Solution Sagethegreenoz ,
try this,
Burndown_Chart =
VAR MaxResolvedDate =
MAX ( 'JIRA_CICD'[Resolved] ) -- Get the latest resolved issue date
VAR TargetValue = 40 -- Set your starting target value
VAR IssuesResolved =
CALCULATE (
COUNT ( 'JIRA_CICD'[Issue key] ),
'JIRA_CICD'[Status] = "Done",
'JIRA_CICD'[Resolved] <= MAX ( 'Calendar'[Date] ) -- Include only up to current month
)
RETURN
IF (
MAX ( 'Calendar'[Date] ) <= MaxResolvedDate, -- Show data only up to resolved dates
TargetValue - IssuesResolved, -- Subtract cumulative resolved issues from target
BLANK () -- Hide future months
)
Thanks for that. Unfortunately the line goes up after the current month again.