Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
PoojaTekriwal
Regular Visitor

Split a column based on where condition from another column

  1. want to split a column contaning this value
  2. asset-symbol column name
C 21/03/19 C 72.000

 

into 4 new column where my assetype(another column containing values equity,option)=equity

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Please try to add 2 new columns:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclYwMtQ3MNY3tFRwVjA30jMwUNJRctXxV4rViVZy93WFShuYAqWNzE1R5b1dQRwwMyTYxxFhVICCqYGBAapiR9+gYIjyWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.BeforeDelimiter([Column1], " ")),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Text.BetweenDelimiters([Column1], " ", ".", 2, 1))
in
    #"Added Custom1"

V-lianl-msft_0-1616746780532.png

 

View solution in original post

4 REPLIES 4
V-lianl-msft
Community Support
Community Support

Please try to add 2 new columns:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclYwMtQ3MNY3tFRwVjA30jMwUNJRctXxV4rViVZy93WFShuYAqWNzE1R5b1dQRwwMyTYxxFhVICCqYGBAapiR9+gYIjyWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.BeforeDelimiter([Column1], " ")),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Text.BetweenDelimiters([Column1], " ", ".", 2, 1))
in
    #"Added Custom1"

V-lianl-msft_0-1616746780532.png

 

amitchandak
Super User
Super User

@PoojaTekriwal , In power query, ISe split option right click of column Based on Space in new 4 columns

refer my Video: https://www.youtube.com/watch?v=FyO9Vmhcfag

or

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

My requirement is that i want to split my first column when my fifth column value is option,equity otherwise no split

PoojaTekriwal_0-1616566632315.png

 

Anonymous
Not applicable

Hello @PoojaTekriwal ,

 

I am not sure its possible to split column with condition. But you can filter the value on the column and then split the column. But that will skipped the other data. I am not sure whether you will get the desired result you want.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.