I am working in Power BI and have dataset with columns containing “Y”, “N”, or “NA”. There are over 100 columns so I am trying not to create an if statement for every column. Is there any way that I can count the number of “Y” in each row for each column? With an example I could do this for the “N” as well. Thanks in advance.