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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Multiplication issue 4th Decimal

In my query, I am multiplying 2 columns.

One of the rows has values:

Column A = 4.0797

Column B = 353

If we multiply we should get 1440.1341

But I am Getting 1440.1383, this is happening for each row generally the 3rd decimal point is coming wrong. I am not sure how to handle this scenario or fix it.

All columns have data type as Decimal and it shows 4 decimal points.

Thank you

Thank you

Hitesh

1 ACCEPTED SOLUTION
Community Support

Try to use ROUND to keep two decimal places. Then, the values of other decimal places will not affect subsequent calculations.

For example,

``Measure = SUM('Table'[Column1])*SUM('Table'[Column2])``
``Measure 2 = ROUND(SUM('Table'[Column1]),2)``
``Measure 3 = ROUND(SUM('Table'[Column2]),2)``
``Measure 4 = [Measure 2]*[Measure 3]``

BTW, .pbix file attached.

Best Regards,

Icey

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

3 REPLIES 3
Community Support

Try to use ROUND to keep two decimal places. Then, the values of other decimal places will not affect subsequent calculations.

For example,

``Measure = SUM('Table'[Column1])*SUM('Table'[Column2])``
``Measure 2 = ROUND(SUM('Table'[Column1]),2)``
``Measure 3 = ROUND(SUM('Table'[Column2]),2)``
``Measure 4 = [Measure 2]*[Measure 3]``

BTW, .pbix file attached.

Best Regards,

Icey

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

Super User

Can you do it with a measure instead?

``Amount = SUMX( 'Table' , 'Table'[Column1] * 'Table'[Column2] )``

Frequent Visitor

Thank you @jdbuchanan71 for replying.

Actually columns are coming from 2 different tables:

I will give you the original multiplication:
SUMX(PlannedRequirements,PlannedRequirements[Plan Buy])*SUMX(FinishedGoods,FinishedGoods[Component Qty Per Assembly]*(100/(100-FinishedGoods[Scrap Factor]))*FinishedGoods[Part Qty Per Assembly])

Column A > SUMX(PlannedRequirements,PlannedRequirements[Plan Buy]) = 353
Column B > SUMX(FinishedGoods,FinishedGoods[Component Qty Per Assembly]*(100/(100-FinishedGoods[Scrap Factor]))*FinishedGoods[Part Qty Per Assembly]) = 4.0797

Now if I multiply these two I am getting the wrong result for the 4th decimal point.

Helpful resources

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Power BI Monthly Update - July 2024

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

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors