Different result in excel and power BI

[Ludwik]

Hi I have A table in Power BI with column "x" with decimal number (value 4950,0000) and column "y" with decimal number 0,1994. I created new column with comand = "x"*"y" and the result is 986,995 but the same calculation in exel equals 987,03. Why this is different? 

[Kedar_Pande]

@Ludwik 

The discrepancy is due to the different ways Power BI and Excel handle decimal precision and rounding.

To align the results between Power BI and Excel, you can apply rounding explicitly in Power BI like this:

NewColumn = ROUND('Table'[x] * 'Table'[y], 2)

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Ludwik]

Hi, I solved this, column "x" was was another calculation with column "z" when I added function round to this column everythin wors properly. Thanks for help.

[dharmendars007 · Accepted solution]

Hello @Ludwik , 

Check Data Types in Power BI, go to the Data View, select the columns x and y, and ensure they are set to Decimal Number (not Fixed Decimal Number).

Use the ROUND or FORMAT function in Power BI to match the precision of Excel.

NewColumn = ROUND('Table'[x] * 'Table'[y], 2)

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[Ludwik]

I've checek both colums they are Decimal numbers. I want to keep 4 decimal places. When i used round function ROUND('Table'[x] * 'Table'[y], 4) I still have different result: Excel 9870,0300 and power Bi 986,9995.

[wini_R]

Hi @Ludwik,

can you please send us a screenshot of your data and formula?