Calculate Number of Days Between Current Date and Another Date

[pav03]

Hello,

I am trying to create a custom field to calculate the number of days between two dates in Power Query.

Parameter one is a datetime field in my existing dataset called [LastModifiedDate], and parameter two should be the current date.

I have tried the following, but it results in every row returning "Error".

Duration.Days([LastModifiedDate] - Date.From(DateTime.LocalNow()))

Is anyone able to advise how to fix this, please?

Thanks!

[BA_Pete · Accepted solution]

Hi @pav03 ,

Try this as a new custom column:

Duration.TotalDays(Date.From([LastModifiedDate]) - Date.From(DateTime.LocalNow()))

Pete

[pav03]

Thank you @BA_Pete , this is exactly what I needed!