topic How to create new column by extracting first two letter or first two number from another column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-new-column-by-extracting-first-two-letter-or-first/m-p/2324644#M58149 <P>I have a&nbsp; column Material . this column combined text and number value like below</P><P>&nbsp;</P><P>Item No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;material&nbsp;</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70.Y808</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; V0P8MC</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10.0000</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40.9JWH</P><P>&nbsp;</P><P>I want to create new column name category this&nbsp; extract first two letter from the material column</P><P>&nbsp;</P><P>output like&nbsp;</P><P>Item No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;material&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Categoey&nbsp;</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70.Y808&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; V0P8MC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;V0</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10.0000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;10</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40.9JWH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40</P><P>&nbsp;</P><P>i have tired few of measure i am getting some&nbsp; column blank .</P><P>&nbsp;</P><P>Looking For support . Thanks in advance ..</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 08 Feb 2022 06:24:17 GMT Anonymous 2022-02-08T06:24:17Z How to create new column by extracting first two letter or first two number from another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-new-column-by-extracting-first-two-letter-or-first/m-p/2324644#M58149 <P>I have a&nbsp; column Material . this column combined text and number value like below</P><P>&nbsp;</P><P>Item No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;material&nbsp;</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70.Y808</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; V0P8MC</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10.0000</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40.9JWH</P><P>&nbsp;</P><P>I want to create new column name category this&nbsp; extract first two letter from the material column</P><P>&nbsp;</P><P>output like&nbsp;</P><P>Item No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;material&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Categoey&nbsp;</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70.Y808&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; V0P8MC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;V0</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10.0000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;10</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40.9JWH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40</P><P>&nbsp;</P><P>i have tired few of measure i am getting some&nbsp; column blank .</P><P>&nbsp;</P><P>Looking For support . Thanks in advance ..</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 08 Feb 2022 06:24:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-new-column-by-extracting-first-two-letter-or-first/m-p/2324644#M58149 Anonymous 2022-02-08T06:24:17Z Re: How to create new column by extracting first two letter or first two number from another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-new-column-by-extracting-first-two-letter-or-first/m-p/2324663#M58152 <P><img /></P> <P>&nbsp;</P> <DIV> <DIV><EM><STRONG>Category CC =</STRONG> </EM></DIV> <DIV><EM>LEFT(Data[material],2)</EM></DIV> </DIV> Tue, 08 Feb 2022 06:32:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-new-column-by-extracting-first-two-letter-or-first/m-p/2324663#M58152 Jihwan_Kim 2022-02-08T06:32:28Z