Forum Discussion

infantpowerbi's avatar
infantpowerbi
Helper II
6 years ago
Solved

How to get the sub-string from the column value

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

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.