Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Can you please post your expected output.
Thanks & Regards,
Bhavesh
Thanks For Rply Me,
I need to create column based on number of character. Here I add following output structure.
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.
Thanks & Regards,
Bhavesh
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |