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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Help with dates range and zero values

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.