Forum Discussion

Akash_003's avatar
Akash_003
Frequent Visitor
2 years ago
Solved

Need decimal values upto 14 digits

Hello All   I have two columns A and B. When I divide A and B I should get C which should be having atleast 12 digits after decimal point. For Example If I divide 9/7 the result should be 1.2857142...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Akash_003 ,

     

    First use the custom column to divide columns A and B to get the Custom column change it to Decimal Number, save it to Desktop, change the Custom column Formatting to 14 decimals, and then enter Power Query and you're done. To verify, I multiplied the custom column. Even though the display is omitted, the actual value is correct (lower left data).

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Akash_003 ,

 

It is possible to keep 14 decimals, where both columns A and B are of Decimal number type, you can check the result as follows:

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Akash_003's avatar
    Akash_003
    Frequent Visitor
    2 years ago

    Ah, thats what I mentioned. I cannot do this in DAX. Need to be done inside. The image is result of division between two columns done in Power Query. I need this number to have 14 decimal places.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Akash_003 ,

       

      First use the custom column to divide columns A and B to get the Custom column change it to Decimal Number, save it to Desktop, change the Custom column Formatting to 14 decimals, and then enter Power Query and you're done. To verify, I multiplied the custom column. Even though the display is omitted, the actual value is correct (lower left data).

       

      Hope it helps!

       

      Best regards,
      Community Support Team_ Scott Chang

       

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

       

      • Akash_003's avatar
        Akash_003
        Frequent Visitor
        2 years ago

        Ah, Thanks. so does that mean the subsequent calculation will be done based on the lower left data?