Change column values based on parameter

[DW868990]

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 the column to then show as:

Is there a way to achieve this?

Thanks

[Anonymous · Accepted solution]

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. 

 

[Idrissshatila]

HEllo @DW868990 ,

Try acheiving this using field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[DW868990]

ah sorry, I wasnt clear, the parameter is a parameter within the power query editor, not a field parameter.