Forum Discussion

JuanPena's avatar
JuanPena
Regular Visitor
4 years ago
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 h...
  • amitchandak's avatar
    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