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?
Many thanks,
Islam
This is in power BI
And here is the pivot table in excel based on the same database:
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
3 Replies
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
- Anonymous ,
make sure it is decimal in DAX
