Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.