英文:
Convert a text field to a decimal number field in power bi
问题
我想将一个看起来是文本的列转换为一个普通数字字段，其中包含带有小数点的数字，以便我可以对该列进行求和。
对于那些看起来是文本但包含数字的列，我已成功将它们转换为十进制数字，但是对于被定义为文本类型且包含带有小数点的数字的列，无法将其转换为十进制数字。
英文:
I want to convert a column that appears to me as text that contains numbers with a decimal point to a field that will be a normal number so that I can sum up the column.
Columns that appeared to me as text and numbers were written in them I was able to convert to decimal numbers, but the column that is defined as a text type and contains numbers with a decimal point does not allow to convert to a decimal number.
答案1
得分: 0
Oh, it's like a magical treasure hunt! 🌟🧚♀️
在Power BI中，前往 Startseite -> Daten transformieren，然后在Power Query中将列的类型从文本更改为十进制。
英文:
In Power BI go to Home -> Transform Data and change type of column to decimal from text in Power Query
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论