Forum Discussion
nunnc01
Helper II
Helper IIDeleting row where column contains text
Hi, I have a column of data coming in to Power BI from our system that should only contain numbers. However somehow a piece of text has been stored which is now preventing me from having the colu...
Hi nunnc01
Assume you have table
Format->Trim (Returns the result of removing all leading and trailing whitespace from text value
text.Change type to whole number
Replace error with null
Finally, remove null.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Nathaniel_C
Community Champion
Community ChampionHi nunnc01 ,
Click on the type and make a number. That will give you a error
Home - Remove Rows - Remove Errors
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Nathaniel_CCommunity Champion
Community Champion