Forum Discussion
Cannot Convert Text to Decimal
Hi everyone! I think I tried posting this question but I'm not sure if it went through because I had to create an account.... so apologies if this is a re-post! I am new to the Power BI Community...
Hi Anonymous ,
Power BI can't recognize the "/" as "÷".
You can use Split feature in Query Editor then add a new column =column1/column2
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
it looks like your "null" is not exactly null.
try to replace value to to '' (blank) before convert the data type