Forum Discussion

hitesh160790's avatar
hitesh160790
Frequent Visitor
6 years ago
Solved

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 f...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi hitesh160790 ,

     

    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.

Icey's avatar
Icey
Community Support
6 years ago

Hi hitesh160790 ,

 

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.