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...

Need Help

Anonymous

2 years ago

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"