Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to replace a value in a column with the column name

Hi there,

 

Could someone please tell me how I can replace values in a column with the column name.

 

As a simple example, I want PQ to replace every 'Nein' with the column name:

 

Nigel_Mayhew_0-1635401822618.png

 

Is this doable?

 

Thanks.

1 ACCEPTED SOLUTION

NewStep= Table.ReplaceErrorValues(PreviousStepName,List.Transform(Table.ColumnNames(PreviousStepName),(x)=>{x,x}))

View solution in original post

4 REPLIES 4
wdx223_Daniel
Super User
Super User

NewStep=Table.TransformColumns(PreviousStepName,List.Transform(Table.ColumnNames(PreviousStepName),each {_,(x)=>if x="Nein" then _ else x}))

Anonymous
Not applicable

Hi Daniel,

 

It works perfectly! Thank you!

 

How can I please apply your solution when I want to replace errors, instead of a specific value, with the column name?:

 

Nigel_Mayhew_0-1635404143005.png

 

Looking forward to hearing back from you.

 

NewStep= Table.ReplaceErrorValues(PreviousStepName,List.Transform(Table.ColumnNames(PreviousStepName),(x)=>{x,x}))

Anonymous
Not applicable

Genius. Thanks very much!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.