Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Delete rows with numbers
05-26-2023
06:22 PM
Hello
Is there any way to eliminate all the rows that have only numbers accompanied by commas and spaces ??
Thanks for the help you can give me.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2023
06:53 PM

You can add a column with this expression, and then filter out the rows with null in the new columns. Replace Column1 with TextN.
= if Text.Length([Column1]) = Text.Length(Text.Select([Column1], {"0".."9", " ", ","})) then null else [Column1]
Pat
Microsoft Employee

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
11-01-2023 11:24 PM | |||
Anonymous
| 02-27-2022 11:08 PM | ||
06-16-2025 11:24 AM | |||
08-03-2021 08:28 AM | |||
08-03-2023 05:00 AM |