Forum Discussion

ElvirBotic's avatar
ElvirBotic
Helper III
4 years ago
Solved

Counting Blank Dates in Date Column

I am trying to solve a problem where I need to count a column "Date Completed" and find out how many records have a blank in the "Date Completed" column. I originally used Measure1 = CALCULATE ( COUN...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi ElvirBotic 

     

    Try this:

    Measure1 =
COUNTROWS ( 'Table1' )
    - COUNTROWS ( FILTER ( 'Table1', Table1[DateCompleted] <> BLANK () ) )




    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

     

     

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi ElvirBotic 

 

Try this:

Measure1 =
COUNTROWS ( 'Table1' )
    - COUNTROWS ( FILTER ( 'Table1', Table1[DateCompleted] <> BLANK () ) )




If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/