How to do it...

To implement this recipe, do the following:

  1. Create the following measures:
Burndown = 
VAR __ReportingDate = DATE(2020,4,1)
VAR __Date = MAX('R07_Calendar'[Date])
VAR __StartDate = MINX('R07_Project','R07_Project'[Start_Date])
VAR __FinishDate = MAXX('R07_Project','R07_Project'[Finish_Date])
VAR __TotalProjectHours = SUMX(ALL('R07_Project'),'R07_Project'[Scheduled_Work])
VAR __TotalConsumedHours =
SUMX(
FILTER(
ALL('R07_Hours'),
'R07_Hours'[Date] <= __Date
),
'R07_Hours'[Hours])
RETURN
IF(
__Date < __StartDate - 1 || __Date > __ReportingDate,
BLANK(),
__TotalProjectHours - __TotalConsumedHours
)

Idealized Burndown =
VAR __ReportingDate = DATE(2020,4,1)
VAR __Date = MAX('R07_Calendar'[Date])
VAR __StartDate = MINX('R07_Project','R07_Project'[Start_Date])
VAR __FinishDate = MAXX('R07_Project','R07_Project'[Finish_Date])
VAR __TotalProjectHours = SUMX(ALL('R07_Project'),'R07_Project'[Scheduled_Work])
VAR __IdealHoursPerDay =
DIVIDE(
__TotalProjectHours,
DATEDIFF(__StartDate,__FinishDate,DAY) + 1,
0
)
VAR __IdealConsumedHours =
__IdealHoursPerDay * (DATEDIFF(__StartDate,__Date,DAY) + 1)
RETURN
IF(
__Date < __StartDate - 1 || __Date > __FinishDate,
BLANK(),
__TotalProjectHours - __IdealConsumedHours
)
  1. On a Report page, create a line chart visualization and place the Date column from the R05_Calendar table into the Axis area. Ensure that this field is set to Date and not Date Hierarchy.
  2. In the same line chart visualization, place the SV_PVSV_EV, and SV$ measures into the Value area.
  1. On the same Report page, create a card visualization and place the Current SV$ measure into the Fields area.
  2. On the same Report page, create another card visualization and place the SVDays measure into the Fields area.