Forum Discussion

whysotan's avatar
whysotan
Regular Visitor
6 years ago

Force Zero for dates using measure

Hello, I have a data sheet that has a list of dates and I need to count how many times those dates show up. Problem is there are some dates that do not show up at all and result in a blank. I need t...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi whysotan,

 

could you provide sample data or a screenshot 

whysotan's avatar
whysotan
Regular Visitor
6 years ago

Hello mwegener,

Here's a picture of the visual.

 

 

As you can see there's some months not showing anything at all and I'd like to have them display 0 instead, main reason is relative date filtering doesn't appear like it works properly if there's any null or blank dates.