Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
31 | |
31 | |
20 | |
15 | |
12 |
User | Count |
---|---|
21 | |
20 | |
16 | |
10 | |
9 |