Forum Discussion
Solved
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 have seen a lot of ways to make a vertical "Countif" but how can I do this operation in a row?
Thank you for your help
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
1 Reply
- amitchandak
Super User
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