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...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi saqibahmad

 

Have you looked at the DATEDIFF function?

 

Column = 
    DATEDIFF(
        'Table1'[Start Date],
        'Table1'[End Date],
        MINUTE
        )

You can choose from a number of different multiples

 

 

  • saqibahmad's avatar
    saqibahmad
    Frequent Visitor
    8 years ago

    phil

     

    Thanks, I had tried your solution but original problem still persists i.e duration values are still incorrecet when compared to Excel outcome.

     

     

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      Are there millisecond values that aren't being displayed due to formatting?

      • 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?