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.
This worked for me, thank you!
Nathaniel_C
Community Champion
Community ChampionHi spaceyjones ,
You are welcome. Please mark as a solution so that others may find this more quickly!
Nathaniel_C