Number of days between dates in M

[johankent30]

How can I calculate the number of days between a date column formatted as "Date" and the current date in the query editor? For example, if my column has 8/5/2019 and the current date is 8/9/2019 then the custom column would read "4". Any thoughts? Thanks!

[jdbuchanan71 · Accepted solution]

Hello @johankent30 

In PowerQuery you can add a custom column and use this formula

Duration.Days (DateTime.Date(DateTime.LocalNow()) - [Your Date Column] )

In DAX you can add a calculated column and use this formula

DATEDIFF([Your Date Column],TODAY(),DAY)