cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
laboatrunner
New Member

if cell has a number delete row

I have a column that cells either have text or have numbers. If the cell is a number, I want the row deleted. Any recommendations?

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Hi @Syndicate_Admin 

Place the following M code in a blank query to see the steps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWSgSTRmAyCUwag8lkpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Duplicated Column" = Table.DuplicateColumn(Source, "Column1", "Column1 - Copy"),
    #"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column",{{"Column1 - Copy", type number}}),
    #"Kept Errors" = Table.SelectRowsWithErrors(#"Changed Type", {"Column1 - Copy"}),
    #"Removed Columns" = Table.RemoveColumns(#"Kept Errors",{"Column1 - Copy"})
in
    #"Removed Columns"

 

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

Syndicate_Admin
Administrator
Administrator

NewStep=Table.SelectRows(PreviousStepName,each not [ColumnName] is number)

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,940)