Forum Discussion

devssolution's avatar
devssolution
Frequent Visitor
9 years ago
Solved

Create column based on Start Index or End Index

Hi All,

 

In power bi can I create column based on start index to end index (or use the dashes to delineate the columns)

 

I think It's possible with Measure Column, but I need to create new column in source. 

Column 1                     Column 2                C3      C4          C5                         C6      C7                        c8          c9          C10                     C11             C12
------------------- ------------------------------ -------- ------ ------------------------------ ------ ----------------------- -------------- ----- ----------------------------- ------------- -----------
00/15-09-062-22W5/0 CHEVRON HZ GRIZZLY 15-9-62-22   0475401 0Z41   Ensign Drilling Inc.              785 02 Aug 2016 02:30:00 AM St. Albert     0045  Chevron Canada Limited                      Drill To LD
00/12-21-063-17W5/2 TRILOGY HZ KAYBOB 12-21-63-17   0478631 0Y52   Precision Drilling Corporation    391 02 Aug 2016 06:00:00 AM St. Albert     A1C9  Trilogy Resources Ltd.                      Resumption 
05/08-32-063-04W6/0 7GEN HZ 105 KAKWA 8-32-63-4     0478444 A6XF   Citadel Drilling Ltd.               1 02 Aug 2016 11:00:00 AM Grande Prairie A54C  Seven Generations Energy Ltd.               Drill To LD
00/04-33-064-22W5/0 HALO MCKINLEY 4-33-64-22        0479187 0X47   Beaver Drilling Ltd.                3 29 Jul 2016 03:45:00 PM St. Albert     A6GH  Halo Exploration Ltd.                       Drill To LD
00/04-33-064-22W5/0 HALO MCKINLEY 4-33-64-22        0479187 0X47   Beaver Drilling Ltd.                3 29 Jul 2016 03:45:00 PM St. Albert     A6GH  Halo Exploration Ltd.                       Drill To LD
05/09-09-064-04W6/0 7GEN HZ 105 KAKWA 9-9-64-4      0479398 A6XF   Citadel Drilling Ltd.               2 02 Aug 2016 08:00:00 AM Grande Prairie A54C  Seven Generations Energy Ltd.               Drill To LD

 

Thanks & Regards,

Sandeep

Show and Tell
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago
    Spoiler
    Hi Sandeep

    Please see below attached file for your solution.


    https://drive.google.com/file/d/0B5-C_3XrFPdOZEYyaDhWOTNIMEU/view?usp=sharing

    Please mark it as a solution if you think it has solved your problem so we can close the thread.


    Thanks & Regards,
    Bhavesh

5 Replies

  • PavelR's avatar
    PavelR
    Solution Specialist
    9 years ago

    Hi devssolution, I am not really clear what is the result that you want. Please can you describe more simple the intended outcome?

     

    Regards.

    Pavel

    • devssolution's avatar
      devssolution
      Frequent Visitor
      9 years ago

      Thanks For Rply Me,

       

      I need to create column based on number of character. Here I add following output structure.

       

       Sample File

      • BhaveshPatel's avatar
        BhaveshPatel
        Super User
        9 years ago

        Hi There,

         

        To do that, 

        Please follow the below stwps:

         

        In the Query Stage,

        Go to Transform tab and select the split column as outlined in screen shot.

        and then select by the number of characters and it will pop up with a dialog box as outlined in below screen shot.

         

        And you are done.

         

        Step 1Step 2

        Thanks & Regards,

        Bhavesh