Forum Discussion
multiplying column including comma's
Hi everyone,
The outcomes of the calculated column (N x cijfer) are incorrect when the column Cijfer has a comma. This column is seen as Text, but when I want to change it to a decimal number, the comma's are erased (e.g. 9.8 becomes 98). So, that doesn't change the calculated column. How can this be fixed?
The Regional settings are in Dutch, so we use comma's instead of dots.
Anonymous
it depends.
- you can replace point to comma in power query editor and then set data type in power query
- you can try DAX VALUE() function to extract text as number
- you can use DAX SUBSTITUTE() function to replace points to comma or vice-versa
- you can use DAX VALUE(SUBSTITUTE()) constraction
and I think there could be a few more solution, you need to try or provide a more detailed data example
2 Replies
Anonymous
it depends.
- you can replace point to comma in power query editor and then set data type in power query
- you can try DAX VALUE() function to extract text as number
- you can use DAX SUBSTITUTE() function to replace points to comma or vice-versa
- you can use DAX VALUE(SUBSTITUTE()) constraction
and I think there could be a few more solution, you need to try or provide a more detailed data example
Thank you!
The first suggestion already worked. I tried to change Text to Decimal number in desktop itself. That didn't work. But changing it in the Power Query-editor did work.