Forum Discussion
Ignoring Text Values
Thank you for the reply. I did that, but everything came back as 0 in the custom column.
are you able to share your pbix or some sample data? all those example have note in them it will come back as 0, you need to remove those text notes if you want to use that data
please provide some sample data in text form
Unfortunately I cannot. 😞 I appreciate your effort though.
well you can provide sample data that isn't real?
however if you want to use the dates that have text in them
(first tell the source if possible to stop doing that ;))
however you need to replace all the text values with '', if there is a patterns of just a few words its easy to do, just replace values in power query replacing all the different words they use with '', then do a trim, and a clean to remove all the white spaces