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 ...
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
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