Difference between to date/time data type

[Anonymous]

Hello Power BI enthusiast,

I would like to calculate the time difference between two date/time data type. I have used the dax function of DATEDIFF as shown below but I think the precision is not correct

When I checked using online calculator, I got the correct value of time difference . Is there any other way to write DAX in order to get the correct precision value ? 

[az38]

Hi @Anonymous 

try without .[Date]. it cut datetime to only Date

 = datediff(V_Incident[Created].[Date];V_Incident[Updated].[Date];SECOND)

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[Anonymous · Accepted solution]

Try this dax.

Hi @Anonymous 

diff = DATEDIFF('Table'[Start Date],'Table'[End date],SECOND)

Cheers,

Pravin Wattamwar