iterating over more than one column to check for a value (in m or dax)

[vanessafvg]

I have 13 columns that i need to check to see if there is a "yes" in any of those columns, what is the quickest to do this.

I know I can use a switch / if statement in DAX and in M but just putting it out there if anyone has any quicker way to do it?

[MarcelBeug · Accepted solution]

If the 13 columns are the only columns, you can add a column in M with formula:

= List.Contains(Record.FieldValues(_), "yes")

If, for instance, the 13 columns are the last 13 columns in your table, the formula would look like:

= List.Contains(List.LastN(Record.FieldValues(_),13), "yes")

[vanessafvg]

ha!  thats perfect thank you