https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-a-specific-excel-formula-to-excel/m-p/2593282#M74758 <P>Hi</P><P>I have a formula I use a lot in my excel analysis, but I want to built into powerBi as a calculated column:</P><P>&nbsp;</P><P>=iferror(MID(A1,FIND("TCN",A1),11),A1)<BR />Can I create a DAX command which does the same?<BR /><BR />Thanks<BR /><BR /></P><P>Kristoffer</P> Tue, 21 Jun 2022 21:12:09 GMT KristofferAJ 2022-06-21T21:12:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-a-specific-excel-formula-to-excel/m-p/2593282#M74758 <P>Hi</P><P>I have a formula I use a lot in my excel analysis, but I want to built into powerBi as a calculated column:</P><P>&nbsp;</P><P>=iferror(MID(A1,FIND("TCN",A1),11),A1)<BR />Can I create a DAX command which does the same?<BR /><BR />Thanks<BR /><BR /></P><P>Kristoffer</P> Tue, 21 Jun 2022 21:12:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-a-specific-excel-formula-to-excel/m-p/2593282#M74758 KristofferAJ 2022-06-21T21:12:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-a-specific-excel-formula-to-excel/m-p/2593437#M74768 <P><SPAN>=iferror(MID([colnum name],FIND("TCN",[colnum name]),11),[colnum name])</SPAN></P> Tue, 21 Jun 2022 23:42:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-a-specific-excel-formula-to-excel/m-p/2593437#M74768 vapid128 2022-06-21T23:42:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-a-specific-excel-formula-to-excel/m-p/2595315#M74898 <P>Hah this was Simple! - was missing a minor thing - THANKS!&nbsp;</P> Wed, 22 Jun 2022 14:36:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Convert-a-specific-excel-formula-to-excel/m-p/2595315#M74898 KristofferAJ 2022-06-22T14:36:41Z