DATEDIFF

[Eesa]

Hi 

I want to calculate the difference between two dates in DATE/TIME format and return the difference in MINUTES. 

the DAX formula as follows:

DateDiff = DATEDIFF(TABLE[Start Date],TABLE[Ended On].[Date],MINUTE)

my question is why are there zero values?The difference in minutes in the first row should be 570 minutes instead it is showing zero?

Both dates format are DATE/TIME format from Power Query Editor.

thank you for your help

@Phil_Seamark 

[adi_dasturkar · Accepted solution]

Please Write below Formula
DateDiff = DATEDIFF(TABLE[Start Date],TABLE[Ended On],MINUTE)

Note - Remove .Date from [Ended On]

Please Accept a Solution if you solved it.