How to get the sub-string from the column value

[infantpowerbi]

Dear All,

I came from tableau background , So kindly please help me I am in my beginning stage.

I am holding a column where it's value is like Q3 2018 , Q4 2018 ,Q3 2019 , Q4 2019 ,Q1 2019 , Q2 2019
And I need to split this value in two new columns one in quarter and other is Year.

Can any one please help me how can I make it

[Anonymous · Accepted solution]

Hi

It is possible to do so in the query editor (in the transform tab).

If it works then please mark it as the solution.