Forum Discussion
Need decimal values upto 14 digits
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 ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.