https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-create2-new-columns-from-yyyymm-to-Year-and-month/m-p/3244800#M119482 <P>BobSled</P><P>Much appreciate your help!</P><P>&nbsp;</P><P>Thank you</P> Fri, 19 May 2023 17:48:14 GMT Anonymous 2023-05-19T17:48:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-create2-new-columns-from-yyyymm-to-Year-and-month/m-p/3243069#M119364 <P>Hello PBI Community Good Day!</P><P>&nbsp;</P><P>Need to add 2 new columns one for year and month from my yyyymm columns below</P><P>&nbsp;</P><P>Much appreciate you time!</P><P>&nbsp;</P><P>Thank you</P><P>&nbsp;</P><P><img /></P><P><img /></P><P>&nbsp;</P> Thu, 18 May 2023 20:59:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-create2-new-columns-from-yyyymm-to-Year-and-month/m-p/3243069#M119364 Anonymous 2023-05-18T20:59:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-create2-new-columns-from-yyyymm-to-Year-and-month/m-p/3243116#M119373 <P>In Transform Data, there is an option to "Split Column" and you can choose to split by number of Charactors. In your case you will want to split by 2. That should seperate the column into 2 for you.</P><P>I put some Images below.</P><P>Hope that helps!</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 18 May 2023 21:58:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-create2-new-columns-from-yyyymm-to-Year-and-month/m-p/3243116#M119373 BobSled 2023-05-18T21:58:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-create2-new-columns-from-yyyymm-to-Year-and-month/m-p/3244800#M119482 <P>BobSled</P><P>Much appreciate your help!</P><P>&nbsp;</P><P>Thank you</P> Fri, 19 May 2023 17:48:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-create2-new-columns-from-yyyymm-to-Year-and-month/m-p/3244800#M119482 Anonymous 2023-05-19T17:48:14Z