Forum Discussion
Helper IISpilt the Columns in Power bi Table
Hi Experts,
I have a PBI Table Active Table with two coulmns(Action_ID and Action_Reactive ) my requirement is by using "Active Table" i want to create Dimension table along with New Column as Test Result . In Test Result i want to show "Action_Reactive" Coulmn field data as Vol and Invol. In Action_Reactive column i have a data like Material,Vol-Notice ,Invol-Coat . So my Requirement is i want display "Test Result'' data Vol-Notice as Vol Invol-Coat as Invol Material as " " (Blank) For Referal please check below screenshot
14 Replies
Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("RchLCoAgEADQu8zaoH/dRVwMIjFgGjoF3T5mIlq+Zy10LRjYkUMhjOCMhV7myJH8rR7EIXF5OQqvHJuUmXzQm76rjHxWvfk73NSLmJKMz8h663+U6gnOPQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [action_id = _t, action_reactive = _t]), #"Modificato tipo" = Table.TransformColumnTypes(Origine,{{"action_id", Int64.Type}, {"action_reactive", type text}}), #"Aggiunta colonna personalizzata" = Table.AddColumn(#"Modificato tipo", "result", each Text.Reverse(Text.AfterDelimiter(Text.Reverse([action_reactive]),"-"))) in #"Aggiunta colonna personalizzata"let Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("RchLCoAgEADQu8zaoH/dRVwMIjFgGjoF3T5mIlq+Zy10LRjYkUMhjOCMhV7myJH8rR7EIXF5OQqvHJuUmXzQm76rjHxWvfk73NSLmJKMz8h663+U6gnOPQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [action_id = _t, action_reactive = _t]), #"Modificato tipo" = Table.TransformColumnTypes(Origine,{{"action_id", Int64.Type}, {"action_reactive", type text}}), #"Aggiunta colonna personalizzata" = Table.AddColumn(#"Modificato tipo", "result", each if not Text.Contains([action_reactive],"-") then " " else Text.BeforeDelimiter([action_reactive],"-")) in #"Aggiunta colonna personalizzata"
- Vijay_A_Verma
Most Valuable Professional
You can select Action_Reactive column - In PQ, Add column menu - Extract - Text before delimiter - Put "-" without quotes in Delimiter and under Advanced options - Select from the end of the input
Mahamood0218Hi
Vijay_A_Verma Anonymous now i am getting the split data
but when i close and apply button in Transform editor i am getting issue like below
Could you please suggest me
- Vijay_A_Verma
Do you have 64 bit of Power BI installed? This you can see in Help - About.
Another thing you can try is to delete existing query and make the query afresh.
- wdx223_Daniel
Community Champion
NewStep=Table.AddColumn(PreviousStepName,"test",each List.Reverse(Text.Split([Action_Reactive],"-")){1}?)
- Mahamood0218
wdx223_Daniel could you please suggest step by step
- Mahamood0218
Vijay_A_Verma wdx223_Daniel Anonymous hi i have created dimension table for split data
could you please sujjest new column(Term_Text coumn ) for display vol,invol,and blank data.
- Vijay_A_Verma
Method will stay the same. There is no change in that.
- Mahamood0218
Vijay_A_Verma in above pic i have created Dimension table so we can try with coding is it possible?
