Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Counting empty row in a date Column

Hello friend,   Thank You for helping figuring out this DAX formula. I'm trying to count empty row in a date column. my initial code was  Pending = COUNTROWS( FILTER('Fact-Tasks','Fact-Tasks'[Clo...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    you can write it like this

    Pending = COUNTROWS( FILTER('Fact-Tasks','Fact-Tasks'[Closed]= BLANK ( ) ))

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

you can write it like this

Pending = COUNTROWS( FILTER('Fact-Tasks','Fact-Tasks'[Closed]= BLANK ( ) ))