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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Issue with handling Decimal data Types

Hi,

I have 2 columns Value and qty both of decimal data type formats. In whole Data range maximum scale of value is 2 and for qty is 3. I have to calculate Cummulative of value and qty and divide them. for eg in my data qtys are like {2.454,234.56,0.01}, as maximum digits after decimal is 3 so when i sum it up result value scale should not exceed 3. In PowerBI when i check the sum its like 1.46E- 11, im not sure how is this possible. to avoid this in power query i grouped up with below mcode

= Table.Group(
#"Changed Type",
{"ID"},
{
{"value", each Number.RoundUp(List.Sum([Value]), 2), type nullable number},
{"Qty", each Number.RoundUp(List.Sum([Qty]), 3), type nullable number}

}
)

result values are 0.1 and 0 which is trustable. My question here is how to achieve this without grouping.

 

Please use the below drive link for the excel files and pbix used.

https://drive.google.com/drive/folders/1XbZgu07goVMzn6Kj8soK2bCP_Xzayhf2?usp=sharing

 

Attached images of source file and pbix file with both scenarios one grouped in power query and another table without grouping.

akash_mohan1810_4-1688611045818.png

 

 

akash_mohan1810_0-1688610860185.png

 

akash_mohan1810_1-1688610890903.png

akash_mohan1810_2-1688610930312.png

 

akash_mohan1810_3-1688610959274.png

 


@amitchandak @Sahir_Maharaj @Greg_Deckler @Ashish_Mathur @Martin_D @Jihwan_Kim 

Thank  for ur patience and reply for this post.

Akash

2 REPLIES 2
Martin_D
Super User
Super User

Try changing the column to fixed decimal type as the last step in Power Query. It's called Currency in Power Query and hast 4 decimal points. According to your description this matches with your requirements.

Anonymous
Not applicable

Thanks Martin,

To be surprised, even for Fixed decimal same results are thrown from PowerBI.

 

akash_mohan1810_0-1688636076291.png

 

akash_mohan1810_1-1688636107726.png

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors