Forum Discussion
Solved
Change column values based on parameter
Hi, I have a true/false parameter within power query. Now within my table I have a column which is the name of each products. But when I have the parameter set as TRUE, I require th...
Hi DW868990 ,
In power query, click "Advanced Editor" and copy and paste the following code.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WciwoyElVitWJVgpITUwsgrGAjFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type), #"Replaced Value" = Table.ReplaceValue(#"Added Index",each [Column1], each if Parameter1=true then Text.Combine({"Prod ",Text.From([Index], "en-US")}, "") else [Column1],Replacer.ReplaceValue,{"Column1"}) in #"Replaced Value"Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi DW868990 ,
In power query, click "Advanced Editor" and copy and paste the following code.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WciwoyElVitWJVgpITUwsgrGAjFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type),
#"Replaced Value" = Table.ReplaceValue(#"Added Index",each [Column1], each if Parameter1=true then Text.Combine({"Prod ",Text.From([Index], "en-US")}, "") else [Column1],Replacer.ReplaceValue,{"Column1"})
in
#"Replaced Value"
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.