Forum Discussion
Replicating excel formula
Hello guys, Can anyone help me i have this excel formula that i need to replicate in power query. Here is my data table. My formula in excel : =IF(X3>=71%,"GOOD",IF(X3>...
I forgot to mentioned that i am using below formula to get average performance for each Questions before doing the formula above
Using formula
=COUNTIF(Data!I:I,K2) and theni just get the average