Forum Discussion

jleotta's avatar
jleotta
New Member
9 years ago

Help with table with calculated colum

Hello,

 

New user of power BI. I am trying to create a column that is the result of two existing columns in my dataset divided together. Very simple. When I execute the DIVIDE function i am getting numbers that are very far off from what the result should be. For example...

 

Column 1 value: 8,344

Column 2 value: 10,141

 

when i divide column 1 by column 2 im getting 675.34% when the answer should be around 82%

 

Any idea what i am doing wrong?

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago
    Hi jleotta,

    Seems like one of the values is not correctly formated making it be much higher or lower than it should check of they bot are as decimal and that the units / decimal values are correct as you need.

    Sometimes making the upload of the data to the queries there are changes because of comas or dots in the information.

    Regsrds,
    MFelix
  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi jleotta,

    As the MFelix posted, please check you upload all the data correctly. What formula do you use? I test it using the formula below, it returns the right result.

    Column = DIVIDE(Table6[Column1],Table6[Column2])




    Best Regards,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi jleotta,

    Have you resolved your issue? IF you have, welcome to share your solution or mark the right reply as answer.

    Best Regards,
    Angelia