Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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, th...
Need Help
  • az38's avatar
    az38
    6 years ago

    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

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

az38 

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.