Forum Discussion
Power BI doesn't use decimals
Never mind,
In the edit query I found that in the "applied steps" window i made 2 (historic) alterations for the data, first I made it a "whole numer" then a couple steps later a "decimal"....deleted the first step and the data came through ok.Solved, -1 kudo for meself!
thanx for the input though!
Helper I
Maybe the Data Type of the column needs to be Decimal Number. I created a new column that adds 2.5 and 3.6 and it shows 6.1. Maybe check your formatting as well?
There seems to be a problem with the upload:
this is mu excel, amount has almost 4 decimals:
tExcel
when uploaded, Power BI just "trims" the amount, and doesn't round it ?
Sorry, it does round it, but the problem is that at a certain point the amounts in the excel are, for example:
0.02
Power BI rounds that to zero.
I have around 60 K-rows with amount €0.02 wich is 1.2 k€, for my purpose reporting thats a material difference :-)
Never mind,
In the edit query I found that in the "applied steps" window i made 2 (historic) alterations for the data, first I made it a "whole numer" then a couple steps later a "decimal"....deleted the first step and the data came through ok.Solved, -1 kudo for meself!
thanx for the input though!
Thanks for the input as it worked perfectly
- sdjensen
Solution Sage
I never liked to use excel as a source for my data. Could you try to save your data excel sheet as a csv file instead and use this as a source and see what you get.
I'm new to Power BI, for the moment my data comes from Excel file (looking to link it directly to ERP database/in cloud applications in the future). Would you advise to always save the Excel data in CSV format?
