February 24, 2016
I've participated in several of your free Pivot / Dashboard webinars. Really good stuff!
I have a column of dates, with some blanks.
In a pivot table I can slicer/filter on specific date values to provide counts. But when I want to count "blank" dates nothing happens. I see "blank" in the date column slicer, I can select it, but nothing is counted.
Googline I found a suggestion to convert the blank cells to a value in a helper column, ie:
This works if it is a column of text values, but not for dates.
I also tried creating a text helper column of the date, ie
The only thing I found that worked specifically for a date column was to enter a dummy value, ie 1, into the blank cells. Once it was converted to 01-00-00 (dd-mm-yy) and another time to 01-01-00. After refreshing the pivot, I could then count these dummy values
Is this a known "feature". or a "FAD" (Failing As Designed)?
Is there some other workaround to count blank dates?