Need to create2 new columns from yyyymm to Year and month

[PBI-Curious]

Hello PBI Community Good Day!

Need to add 2 new columns one for year and month from my yyyymm columns below

Much appreciate you time!

Thank you

[PBI-Curious]

BobSled

Much appreciate your help!

Thank you

[BobSled · Accepted solution]

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.

I put some Images below.

Hope that helps!