Forum Discussion
Exclude blank from date column as a count
Hi Experts
I am trying to count the nunber of dates in a column in Table A, and exclude the (blank) in the column.
my Measure is
= Calculate(countrows(table A),filter(table A, table A[Column] <> blank())
this is giving me the worng answer
Anonymous You could try NOT(ISBLANK
= Calculate(countrows(table A),filter(table A, NOT( ISBLANK( table A[Column]) ) ) )
Otherwise why don't you just count the values in the column? It won't count it if it's truly blank:
= COUNT(TableA[Column] )
If that doesn't work, it might be possible that it's not actually blank and ="" instead
2 Replies
Anonymous You could try NOT(ISBLANK
= Calculate(countrows(table A),filter(table A, NOT( ISBLANK( table A[Column]) ) ) )
Otherwise why don't you just count the values in the column? It won't count it if it's truly blank:
= COUNT(TableA[Column] )
If that doesn't work, it might be possible that it's not actually blank and ="" instead