Count blank cell per row

[Anonymous]

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]

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]

These are text column

If i do columnA=""" i get True or False, i need to count blank cells

Thansk

[JosefPrakljacic · Accepted solution]

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 

Please give it first a try...

BR,

Josef

[Anonymous]

Works Thanks

[JosefPrakljacic]

You are very welcome 😃