Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
andrekroker
Resolver I
Resolver I

Burnup chart with variable scope line accross all sprint days

Hi All(),
I´ve seen this video https://www.youtube.com/watch?v=uq5PQg_hZro (BI Ellite) on how to build an effective Burndown Chart. After some changes, I´ve set up what I think I had to build my own Burnup chart.


So, given the following Burnp chart already started in PowerBI:
BurnUp Chart 2.jpg
And these assumptions:
- Sprint starts on May 25th and ends on May 31th.

- 'Scope' means planned story points. If story points are added into the sprint at least 1 day after its start, the chart should display the increase/decrease in scope (the actual scope).
- 'Planned' stands for the total amount of actual story points scope divided for each sprint day. It is a measure of how many story points the team should get done every day
- 'Done' Is the actual pace.

To address the scope line I have this DAX Measure:


Burnup (Scope) =

VAR SprintStartDate = CALCULATE(FIRSTDATE(Table[Iteration Start Date]),ALLSELECTED(Table))
VAR SprintEndDate = CALCULATE(FIRSTDATE(Table[Iteration End Date]),ALLSELECTED(Table))
VAR DaysSinceStart = DATEDIFF(SprintStartDate, MAX(dCalendario[Date]),DAY)
VAR InitialScope = CALCULATE([Burnup InitialScope], ALLSELECTED(Table))
VAR ActualScope = CALCULATE([Burnup ActualScope], ALLSELECTED(Table))
VAR DiffScope = ActualScope - InitialScope
VAR SprintLength = CALCULATE([Total Sprint Days], ALLSELECTED(Table))-1

RETURN
IF(
   MAX(dCalendario[Date]) >= SprintStartDate && MAX(dCalendario[Date]) <= SprintStartDate + SprintLength,
      IF(
         DaysSinceStart = 0, InitialScope,
         InitialScope + DiffScope
      ),
   BLANK()
)
------
The Problem:
Given the values for initial and actual scope I have to date:
Burnup chart scope dataBurnup chart scope data
The above table means in May,27th 29 story points were added into the sprint. So I want the grey line (scope) to show these values for each date:
25/05/2020 = 70 Ok
26/05/2020 = 70 instead of 99 that is being shown.
27/05/2020 = 99 Ok
28/05/2020 = 99 Ok
29/05/2020 = 99 Ok

According to the above list, how can I make this values to show properly? 


1 REPLY 1
andrekroker
Resolver I
Resolver I

@v-gizhi-msft  would highly appreciate your comments on this

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.