topic Re: Difference between to date/time data type in DAX Commands and Tips

Difference between to date/time data type

Anonymous — Tue, 24 Dec 2019 02:08:25 GMT

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 ?

Re: Difference between to date/time data type

az38 — Tue, 24 Dec 2019 07:33:48 GMT

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

Re: Difference between to date/time data type

Anonymous — Thu, 26 Dec 2019 09:00:38 GMT

Try this dax.

Hi Anonymous

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

Cheers,

Pravin Wattamwar