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...
v-juanli-msft
Community Support
Community SupportHi 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
Maggie
Maggie
Community 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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Whibley92Helper II
Helper III am trying to perform this on a column with only 2 sets of criteria (I'm very new to Power BI). I would like to permanently deleted the rows with one particular category, rather than just filtering out as there is a lot of data. How do I perform this?