Rename all row values of a data-set in a single column to the same name .

[Anonymous]

Hello,

Could you please offer any suggestion about how to rename all of the row vlaues in a single column to the same name?

For example,  for a data-set in PowerBI, in the column X, all of the row values will be named as Y.

Thank you! 

Rahat

[amitchandak]

@Anonymous , Not very clear. If you want to replace a value you have an option in edit query/data transformation for replacing the value

https://yodalearning.com/tutorials/learn-how-replace-values-power-query/

https://www.youtube.com/watch?v=UZQ9EFvEECY

https://www.youtube.com/watch?v=MLrRlPh_ZFQ

If you need a static value, You can create a new column

New Column = "Y"

[Anonymous]

Hi Amit,

Pretty close 🙂 

Actually the replace is pretty much like what is stated in the screenshot.

[Icey · Accepted solution]

Hi @Anonymous ,

Try this:

= Table.AddColumn(#"Removed Columns", "Custom", each if [Name] <> "" then "Gateway" else "")

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks, Icey! 🙂

[mahoneypat]

Not sure if this is what you mean, but you can just add a custom column and in the pop-up formula box put = "Y", and then rename that new column to "X".  And delete the original column that you intended to replace with Ys.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[lbendlin]

Why?  How is that different from deleting the row?