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.