Forum Discussion

saqibahmad's avatar
saqibahmad
Frequent Visitor
8 years ago

Problem with Decimal Values in DAX, Excel(Precisely Correct ) vs Power BI (Incorrect)

Hi ,   Following is an example dataset from EXCEL and Power BI. Look at Duration column.... values doesnt match between both. I have tried changing formating Decimals, text, general in PowerBi to f...
saqibahmad's avatar
saqibahmad
Frequent Visitor
8 years ago

If apply formating then results end up as rounded which is not what i  want.

values before converting to milli seconds dont event match with the results in Excel.

 

Now i have moved onto reporting and further calculation and the end results shows that there are much difference in Poweer BI reports vs Excel outcomes.

 

I think either of the system is applying some formating unwantedly or am i using incorrect functions?

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi saqibahmad,

 

It seems that a problem with decimal point accuracy for Date type in Power BI.

 

By my tests with calculating the decimal number in Power BI and Excel, the results are the same.

 

 

 

Actually, we'd better use the dax formula mentioned by Phil_Seamark to calculate the Date difference in Power BI.

 

If you really want to use the result calculated in Excel, as a workaround, you could calculated the date difference in Excel first then import the data to Power BI.

 

Best Regards,

Cherry