Forum Discussion

thegreenoz's avatar
thegreenoz
Frequent Visitor
1 year ago

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...
Need Help
thegreenoz's avatar
thegreenoz
Frequent Visitor
1 year ago

The data for JIRA looks like:

 

The shared calendar:

 

And what im getting as far as the UI

manikumar34's avatar
manikumar34
Solution Sage
1 year ago

thegreenoz ,
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
)

  • thegreenoz's avatar
    thegreenoz
    Frequent Visitor
    1 year ago

    Thanks for that. Unfortunately the line goes up after the current month again.

  • thegreenoz's avatar
    thegreenoz
    Frequent Visitor
    1 year ago

    Hi, also we shouldnt go from 10 to 1, this is a month over month and not an accumulated tally which should be adding (increasing) overtime)