Forum Discussion
Count blank cell per row
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
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
These are text column
If i do columnA=""" i get True or False, i need to count blank cells
Thansk
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
- Works Thanks