Forum Discussion

netteSJ's avatar
netteSJ
Frequent Visitor
3 years ago

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>...
Need Help
Show and Tell
Tips and Tricks
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

In power query: 

= Table.AddColumn(Custom1, "Performance", each if [ColumnX] >= 71 then "GOOD" else if [ColumnX] >= 50 then "SATISFACTORY" else if [ColumnX] >= 1 then "NEED IMPROVEMENT" else null)