I have this written in DAX but I actually have to write it in Power Query. I need a column that adds a 1 if the other columns do not equal “NA” and then adds the 1s together. So if column 1, 2, and 3 were yes and column 4 and 5 were NA then the new column would be the number three.

1. new column = 
IF(table[column_1)]<>"NA",1,0)+
IF(table[column_2]<>"NA",1,0)+
IF(table[column_3)]<>"NA",1,0)+
IF(table[column_4)]<>"NA",1,0)+
IF(table[column_5)]<>"NA",1,0)