DAX to create new column with if/or statement

[JeffreeN]

I am new to Power BI, and not yet across DAX.

I have 7 existing columns with yes / no data:    "as"    "ts"    "hns"   "mhs"    "ws"     "cs"    "rtc"

I need a new column to effect of: if "as" or "ts" or "hns" or "mhs" or "ws" r=or "cs" or "rtc" = yes, return yes, otherwise return no 

[ThxAlot]

It's way more concise and robust to use PQ to achieve this result

= Table.AddColumn(Source, "Chk", each if List.Contains(Record.ToList(_), "Yes", Comparer.OrdinalIgnoreCase) then "Yes" else "No")

[rubayatyasmin]

Hi, @JeffreeN 

see if this DAX works. 

New Column =
IF(
OR('Table'[as] = "Yes", 'Table'[ts] = "Yes", 'Table'[hns] = "Yes", 'Table'[mhs] = "Yes", 'Table'[ws] = "Yes", 'Table'[cs] = "Yes", 'Table'[rtc] = "Yes"),
"Yes",
"No"
)

it will return yes if any of the column value is yes. other wise it will return no. 

If my assistance helped you in any way, hit 👍.