Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Difference between to date/time data type

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 ? 

DAX
  • Anonymous's avatar
    Anonymous
    6 years ago

    Try this dax.

    Hi Anonymous 

     

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

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Try this dax.

      Hi Anonymous 

       

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