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>...
Add column
Performance =
IF('Table'[toal score]>=71/100,"Good",IF('Table'[toal score]>=50/100,"Statisfactory","need"))
try this. Make changes as per your categories you have.
regards,
Aditya