How to do it...

To implement this recipe, do the following:

  1. Create the following measures:
Running Monthly Revenue = 
VAR __Date = MAX('R07_Revenue'[Date])
VAR __Month = MONTH(__Date)
VAR __Year = YEAR(__Date)
RETURN
SUMX(
FILTER(
ALL('R07_Revenue'),
MONTH([Date]) = __Month &&
YEAR([Date]) = __Year &&
[Date] <= __Date
),
'R07_Revenue'[Revenue]
)

Running Monthly Budget Per Day =
VAR __Date = MAX('R07_Revenue'[Date])
VAR __Month = MONTH(__Date)
VAR __Year = YEAR(__Date)
VAR __Day = DAY(__Date)
VAR __Budget =
SUMX(
FILTER(
'R07_Budget',
MONTH([Date]) = __Month &&
YEAR([Date]) = __Year
),
[Budget]
)
VAR __Days = DAY(EOMONTH(DATE(__Year,__Month,1),0))
RETURN
__Budget * __Day / __Days
  1. On a Report page, create a Clustered column chart visualization and place the Date column from the R07_Revenue table into the Axis area and place the Running Monthly Revenue and Running Monthly Budget Per Day measures in the Value area.