Forum Discussion
Ignoring Text Values
so are you saying you dont need to clean those values you just want to ignore them?
otherwise you will have to clean your data first. you can't convert the data to a number without cleaning it.
what you can do is create a flag in power query (its more performant that way if using import mode) to identify the numbers only
in power query create a custom column
if Value.Is([field_name],type number)
then 1
else 0
you can then create a measure that allows you to convert to a number by either using this flag in the filter or just create a conditional column in power query to create a new column where the custom column = 1
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.
