Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I need some help with the data im working on, I'm trying to breakdown a column into three new columns on PowerBI
Conditions
Solved! Go to Solution.
See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcrEwC1eK1YlWcjQxhdAWFhABCwtVqIApVIWZGZg2N4DwLS1VoQohlCVEGGJiLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Default Header" = _t]),
#"Added Custom" = Table.AddColumn(Source, "Actual%", each Text.Select([Default Header],{"0".."9"}), type number),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Left", each if List.Contains({"A".."Z"},Text.Start([Default Header],1)) then Text.Start([Default Header],1) else null, type text),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "Right", each if Text.EndsWith([Default Header],"W") then "W" else null, type text)
in
#"Added Custom2"
See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcrEwC1eK1YlWcjQxhdAWFhABCwtVqIApVIWZGZg2N4DwLS1VoQohlCVEGGJiLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Default Header" = _t]),
#"Added Custom" = Table.AddColumn(Source, "Actual%", each Text.Select([Default Header],{"0".."9"}), type number),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Left", each if List.Contains({"A".."Z"},Text.Start([Default Header],1)) then Text.Start([Default Header],1) else null, type text),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "Right", each if Text.EndsWith([Default Header],"W") then "W" else null, type text)
in
#"Added Custom2"