Forum Discussion

cubedweller's avatar
cubedweller
Regular Visitor
8 years ago

fill in missing dates

Hi, I would like to fill in missing dates and add zeros as their count. For example, I have 9/16/17 (count=2) and 9/18/17 (count=3). I would like to add 9/17/17 with count=0. Thank you.  
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Going to be very difficult to answer without sample data, but you might be able to use something like a Date/Calendar table that has all of the dates and a measure or calculated column in the format of:

 

IF(ISBLANK(COUNT([column)),0,COUNT([column])