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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Power Query delete/change values in existing column

Hello friends,

How can I delete all values in existing column? Without deleting it and creating a new, empty one?

Another question is: how do I change all different values in an existing column to some specific value? Also without creating a new column?

Thank you

Michael

1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

This will change all values in Column2 of table Source to null.

Adjust as required.

 

= Table.TransformColumns(Source,{{"Column2", each null}})
Specializing in Power Query Formula Language (M)

View solution in original post

3 REPLIES 3
VesnaStojTraj
New Member

Thank you. I have used it also.

MarcelBeug
Community Champion
Community Champion

This will change all values in Column2 of table Source to null.

Adjust as required.

 

= Table.TransformColumns(Source,{{"Column2", each null}})
Specializing in Power Query Formula Language (M)
Anonymous
Not applicable

Exactly what I needed!
Thank you!
Michael

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Users online (488)