Forum Discussion
Power BI figures different VS same data base excel pivot table
Hello, Il creating a very simple reports, but I dont know why the figures in power BI do not match with excel. Attaching both documents. If anyone could help me? The power BI doc The e...
Anonymous , Open power query and check Data type of Kur is decimal at the very first change type.
If it is a whole number or it was first made a whole number and then a Decimal, both will create an issue
Also make sure it is decimal in DAX too
amitchandak
Super User
Super UserAnonymous , Open power query and check Data type of Kur is decimal at the very first change type.
If it is a whole number or it was first made a whole number and then a Decimal, both will create an issue
Also make sure it is decimal in DAX too
Ah! Thank you so much! It worked!
As Im going to add on top of this database each week additional one, do I need each time change it to decimal? Or it's automatic from now on?