Forum Discussion
DataFormat.Error: we couldn't convert to Number
Dears, i was looking to replace( '- ) with ( - ) since in my Excel sheet i have some values with '-70000. the dash caused a problem. when trying to replace it in power query it doesn't allow me ...
Hi Zakaria_1980
I think this should work for you:
#"Transform Stuff" =Table.TransformColumns(PreviousStep,{{"Value", (t) => Number.FromText(Text.Replace(Text.From(t), "'", "")), type number}, {"Date", Date.From, type date}})
You should change PreviousStep to the previous step of your query.
I think this should work for you:
#"Transform Stuff" =Table.TransformColumns(PreviousStep,{{"Value", (t) => Number.FromText(Text.Replace(Text.From(t), "'", "")), type number}, {"Date", Date.From, type date}})
You should change PreviousStep to the previous step of your query.
please tell me exacetly how can i implement what you have proposed ? i'm beginner in using PBI.
Thanks a lot