Forum Discussion
trying to check whether a text column contains a number using M
I am handling a column , it has majorly text values but occasinally some number values that are similar to 1234.4567, 1234.5678 or 3222.7869 type numbers . ( pls note all of these numbers has fou...
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi avininpowerbi,
Could you provide a screenshot of the data as well as of the code for the custom column?
thanks 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Thanks for your help ! since I had no luck extracting the numbers, I used Replace Value ( .00 as the string) with XYZ. Then after, I added a conditional column and used Text.contains . Thats it.