How to write formula in power query compared excel table formula

[aam1932]

Hai all

Appreciate anybody can help me on how to write formula in power query if the formula in excel table as below :

=IFERROR(MID([@Description],FIND("CustRef",[@Description],1),30),"")

Thank you

 

[RudiS]

Try this

In your query, click the Custom Column button on the Add Column Tab.
In the textbox, type a name for your new column
In the formula window paste the following after the = sign:

try Text.Middle([Description], Text.PositionOf([Description], "CustRef"), 29) otherwise null