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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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