Forum Discussion
Issues with conversion from text to decimal
Hello to everyone. I faced with issue of interpreting of column type by PowerBI. Loading data from data warehouse, the type of one of columns from fact table was determined as text, despite, insi...
Hi, Phil
Really grateful for your answer.
I inspected my column as you recommended, and, to my surprise, it displays all cells as invalid
And I have no idea, what caused such behavior and what the are the ways fo solve that problems
Sincerely,
Fedir
Hi fedosklyar
Perhaps you have missed PhilipTreacy 's first sentence "To manually specify a decimal data type just use type number ". See below image, either "type number" or Decimal.Type should work. "type Decimal.Type" is incorrect.
Best Regards,
Jing