Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Count blank cell per row

Hi,

how can i achieve this?

I want to creare "Error" column to count how many blanks cell in "A_CN A_TR P_CN P_TR" columns.

Thanks

JosefPrakljacic
6 years ago
I know that your columns are text columns.

True|False represent 1 and 0 and as you can see in my post I'm converting them with INT.
So yes you could count your Blank Cells since A=="" would result in TRUE and this would result in the number 1 by using the INT function summing the 1s would result in your count value :smileyvery-happy:

Please give it first a try...

BR,
Josef

5 Replies

JosefPrakljacic
Solution Sage
6 years ago
Hey Anonymous ,

you create a calculated column like this one

YourColumn = INT('Table'[A]=="")+INT('Table'[B]=="")

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria
- Anonymous
  Not applicable
  6 years ago
  These are text column
  
  If i do columnA=""" i get True or False, i need to count blank cells
  
  Thansk
  - JosefPrakljacic
    Solution Sage
    6 years ago
    I know that your columns are text columns.
    
    True|False represent 1 and 0 and as you can see in my post I'm converting them with INT.
    So yes you could count your Blank Cells since A=="" would result in TRUE and this would result in the number 1 by using the INT function summing the 1s would result in your count value :smileyvery-happy:
    
    Please give it first a try...
    
    BR,
    Josef

Related content