Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

COUNTA if blank

Hello   I am using COUNTA to count whenever there isnt a date in a row and then i put it in a card to showcase count. DOScountbypurchase = COUNTA(Table[Dateofpurchase])   When I select a value ...
Tips and Tricks
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

Anonymous 

you can try this

 

DOScountbypurchase = COUNTA(Table[Dateofpurchase]) +0

 

or 

 

DOScountbypurchase =if(isblank( COUNTA(Table[Dateofpurchase])),"No Dates")