DATEDIFF not working

[Pick]

Hi,

  Why is DATEDIFF not working below?

[smpa01 · Accepted solution]

@Pick please try this

DATEDIFF('Table'[Start],'Table'[End],SECOND)

[tkirilov · Accepted solution]

Hi @Pick ,

You'd need to remove .[Date] from both dates, as well as have Start Date first, End date second, unless you'd like to have your answers (seconds) in negative numbers.

DATEDIFF(<start_date>, <end_date>, <interval>) 

[smpa01 · Accepted solution]

@Pick please try this

DATEDIFF('Table'[Start],'Table'[End],SECOND)

[amitchandak]

Remove .[date] from both places .