Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Akash_003
Frequent Visitor

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.2857142857142 but Power BI somehow rounds it off to 7 places. 

The Reason I need is, I am trying to automate a Excel workflow which has lot of calculations. If I calculate with 7 digits after decimal point my end result is off by minimum of 100-2000 depending on the number of digits. I tried rounding off, changed typeetc nothing worked.

Any help to set the digits after decimal upto 14 would be a nice help.
Note: I cant do DAX because the resulatant column will be used in Subsequent columns.

1 ACCEPTED SOLUTION

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).

vtianyichmsft_0-1701067558965.png

vtianyichmsft_1-1701067576596.png

vtianyichmsft_2-1701067611027.png

 

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.

 

View solution in original post

7 REPLIES 7
v-tianyich-msft
Community Support
Community Support

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:

vtianyichmsft_1-1701051626566.png

 

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.

 

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.

Akash_003_0-1701058645476.png

 

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).

vtianyichmsft_0-1701067558965.png

vtianyichmsft_1-1701067576596.png

vtianyichmsft_2-1701067611027.png

 

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.

 

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

Hi @Akash_003 ,

 

I think it works!

 

Best regards,
Community Support Team_ Scott Chang

 

parry2k
Super User
Super User

@Akash_003 What is the data type of col a and col b, is it a whole number or decimal?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Its Decimal, parry2k

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.