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.
New column =
var _pos = search("/",[column],,0)
var _len =len([column])
return
if(isblank([column]),0,divide(left([column],_pos-1),right([column],_len-_pos)))