DAX Help - Line Chart displays for full quarter

[Benx]

Hello All!  

I'm working with some sample Jira data, and trying to create a line chart that shows the changes in total Estimated Story Points, and Unestimated Story Points throughout a full quarter, running from 7/1 through 9/30. The sample data I'm working with only has data updates on 7/20, 7/21, 7/22, 7/25, 7/26, 7/28, 8/1, and 8/24, but I'm trying to get the line charts to start on 7/1, and display the last-updated totals through the end of the quarter.

Here's what I've been able to achieve so far:

Here are the two DAX measures I've used in the above visual:

Estimated Story Points (repeating) =
VAR StoryPoints =
    SUM ( 'Repeating Story Table Test'[Story Points] )
RETURN
    CALCULATE ( StoryPoints, REMOVEFILTERS ( Dates[Date] ) ) + 0

Unestimated Stories (repeating) =
VAR StoryCount =
    DISTINCTCOUNT ( 'Repeating Story Table Test'[Story Issue Key] )
VAR UnpointedStories =
    CALCULATE (
        StoryCount,
        'Repeating Story Table Test'[Story Points] = BLANK ()
            || 'Repeating Story Table Test'[Story Points] = 0
    )
RETURN
    CALCULATE ( UnpointedStories, REMOVEFILTERS ( Dates[Date] ) ) + 0

Here's a view of the data I'm working with:

Here's a view of the Date/Calendar table the above table is related to using the Update date:

Any help you can offer wold be much appreciated!

[v-shex-msft · Accepted solution]

Hi @Benx,

You can use the calendar table as the axis of the chart, modify your formula to change the condition to 'less than or equal to' the current date values, and add +0 after the formula to expand calculations on the date ranges.
After these steps, you need to add an if statement package above formula to compare the current date and quarter to confirm these calculations are processed on the specific date ranges.
Regards,

Xiaoxin Sheng