Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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[Colu...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    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

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    thanks Allison....