Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I am trying to replicate this SQL query in Power BI power query.
Solved! Go to Solution.
Paste the code below into the Advanced Editor. The magic happens at the #"Add New Column" step.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQzMtQzMHTUqwACXXMDAyUdpQBfEwOl2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [WBS = _t, #"Task Name" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"WBS", type text}, {"Task Name", type text}}),
#"Add New Column" = Table.AddColumn(#"Changed Type","New Column",
each Text.BeforeDelimiter([WBS],"xxxx") & [Task Name] & Text.AfterDelimiter([WBS],"xxxx"), type text)
in
#"Add New Column"
See also the Add Custom Column:
Paste the code below into the Advanced Editor. The magic happens at the #"Add New Column" step.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQzMtQzMHTUqwACXXMDAyUdpQBfEwOl2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [WBS = _t, #"Task Name" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"WBS", type text}, {"Task Name", type text}}),
#"Add New Column" = Table.AddColumn(#"Changed Type","New Column",
each Text.BeforeDelimiter([WBS],"xxxx") & [Task Name] & Text.AfterDelimiter([WBS],"xxxx"), type text)
in
#"Add New Column"
See also the Add Custom Column:
Thank you very much @ronrsnfld worked great!!!!
Wow alot more to it than i thought the SQL syntax is much easier.
I appreciate your help.
You can use syntax similar to SQL:
Text.Replace([WBS],"xxxx","Task Name")
However, using the diagnostic tools available in Power BI, that syntax runs considerably slower than the more complicated version I presented.