fill in missing dates

[cubedweller]

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.

[Greg_Deckler]

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])