Forum Discussion
Ignoring Text Values
Hi all, I have this measure to count how many estimates are more than 2 days old by converting the first 5 values of the estimates notes column to a dd/mm date. The problem is, some of the estim...
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