Forum Discussion

weilai0521's avatar
weilai0521
Frequent Visitor
7 years ago
Solved

Count columns with 'Yes'

Hi,    I have multiple columns with 'Yes', 'No' or missing (null or '.'). I want to create a Count column that count the number of 'Yes' for each row.    For example, if I have the following data...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    weilai0521 

     

    As a calculated column, you can use

     

    Column = VAR myrow={[A],[B],[C],[D]}
RETURN
COUNTROWS(Filter(myrow,[Value]="Yes"))
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

weilai0521 

 

As a custom column using Power Query / M

 

=List.Count(
    List.Select(
    Record.ToList(_),each _ ="Yes"))