Calculate time between two dates

[Vtomsons]

Hi,

Trying to do a simple calculation of days between two dates but although their are no syntax errors in my custom column and error "Expression Error: The name "DATEDIFF" wasn't recognized. Make sure its spelled correctly" comes up. Here's my formula:

DATEDIFF(MIN( Calendar[Enrollment date.Current Registration Status Date] ), MAX( Calendar[Last Accessed]), DAY)

I joined two separate tables so that my dates are in the same Query but I don't think that's the issue. What am I doing wrong?

Thanks,

Val

[Greg_Deckler · Accepted solution]

(MIN( Calendar[Enrollment date.Current Registration Status Date] ) - MAX( Calendar[Last Accessed]) * 1.

[v-kelly-msft · Accepted solution]

Hi @Vtomsons ，

If it needs to be done in power query,using below M code:

Custom = Duration.Days([Date2]-[Date])

And you will see:

If it is done in report view,using below dax expression to create a measure:

Measure = DATEDIFF(SELECTEDVALUE('Table'[Date2]),SELECTEDVALUE('Table'[Date]),DAY)

And you will see:

Or you can create a calculated column as below:

Column = DATEDIFF('Table'[Date],'Table'[Date2],DAY)

And you will see:

Hope the above is what you need.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Vtomsons]

Thanks fellas for the insight. New to all this so it will get easier...I hope.

[Greg_Deckler · Accepted solution]

(MIN( Calendar[Enrollment date.Current Registration Status Date] ) - MAX( Calendar[Last Accessed]) * 1.

[Vtomsons]

Still getting the error"the name MIN wasn't recognized. Make sure its spelled correctly"

Do these two date columns need to be formatted some way? I have them in the date/time

[Greg_Deckler]

And make sure that you are somewhere that you should be entering DAX code, and not in Query Editor.

[Greg_Deckler]

Oh, dude,

Measure = (MIN( Calendar[Enrollment date.Current Registration Status Date] ) - MAX( Calendar[Last Accessed]) * 1.