Replace missing dates with 0

Question

I have missing dates in my dataset that I am using. So, basically i want to replace the those with '0' so that when i create my line graph , it gets passed through.

Answer 1

Create a calculated field for your dates and use this - 

IF [date]=NULL THEN 0 ELSE [Measure]

This will work for you!