Help with dates range and zero values

[Anonymous]

Hi, this is the situation:

I have Sprint Days and I count the stories in those Sprints. The thing is that maybe in the first or two days of Sprints, there are no Stories. I have to show Zero in that days instead of blank.

Now, the measure looks like that, it has a condition to put blanks in those future days in the sprint where there are no data:

IF(MAX ( 'BuildBurnUp'[SprintDays])>Today(),BLANK(),CALCULATE (
     SUM('BuildBurnUp'[Actual Build Completed Stories]),
    FILTER (ALLSELECTED ('BuildBurnUp'[SprintDays]),'BuildBurnUp'[SprintDays] <= MAX ( 'BuildBurnUp'[SprintDays]))
))

So the missing part would be force zero values when the first days of Sprint has no data.

Thanks in advance

[Anonymous · Accepted solution]

before asking question always share sampla data and expected output so that it will be easier for others to help you.

If you want replace those blanks with 0 in your formula then simple add 0 after if condition part instead of blank.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.