Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to count non empty and non blank cells?

Hello   I want to count non empty and non blank cells.   My table has 100 blank cells and 100 that do not contain any character (they may contain spaces or newlines or simply nothing).   Both t...
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like

countX(filter(Table, not(isblank(Table[column])) && TRIM(Table[column] <> "")),Table[column])