Forum Discussion

rbrechet's avatar
rbrechet
Helper I
9 years ago
Solved

text to value doesnt consider decimal

Hi everyone,

 

My power bi is getting is data from csv database, in which all data is text.

Consequently all data in my PBI are type text to.

 

When I want to convert text to value: "sales amount" or "kg sold" i face an issue:

25,00 will appears as 2500 and 0,4 as 4  so I cannot convert and dived by 100

 

How can I force PBI to consider coma as separating decimal (i tried to use regional settings but didn't works)

 

Hope I am being undestendable ... and many thanks for you support

 

 

Have a great day,

Tips and Tricks
  • dilumd's avatar
    dilumd
    9 years ago

    I don’t know whether I understood correctly,

     

    If this is the always the case in these two column you can simply use replace function in query editor and replace all "," with "."

    Hope this helps you.

2 Replies

  • dilumd's avatar
    dilumd
    Impactful Individual
    9 years ago

    I don’t know whether I understood correctly,

     

    If this is the always the case in these two column you can simply use replace function in query editor and replace all "," with "."

    Hope this helps you.

    • rbrechet's avatar
      rbrechet
      Helper I
      9 years ago

      Hi Dilumd,

       

      Many thx for your quick and clair answer.
      This worked for me !!

       

      So great to have this PBI community 

       

      Wishing you a great week