Forum Discussion
JuanPena
4 years agoRegular Visitor
Horizontal Countif in Power BI
Hi, I am trying to do a horizontal countif in Power BI desktop. I am trying to count the number of times the word "BUENO" appears on each row for all the different columns of the table? I h...
- 4 years ago
JuanPena , You have create a new column like this
= if([col1]= "BUENO",1,0) + if([col2]= "BUENO",1,0) + if([col3]= "BUENO",1,0)
Add all required columns with correct name
amitchandak
Super User
4 years agoJuanPena , You have create a new column like this
= if([col1]= "BUENO",1,0) + if([col2]= "BUENO",1,0) + if([col3]= "BUENO",1,0)
Add all required columns with correct name