Power BI figures different VS same data base excel pivot table

[IslamDadov]

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 excel doc 

Many thanks,

Islam 

This is in power BI

And here is the pivot table in excel based on the same database:

[rajasekar_o]

@IslamDadov ,

make sure it is decimal in DAX

[amitchandak · Accepted solution]

@IslamDadov , 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

[IslamDadov]

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?