Forum Discussion
Solved
Calculate difference between two dates power query
How do I calculate the difference between two dates in Power Query M code (not DAX)? I'm looking for the number of days.
Hi jshutters
you need to use the duration functions: https://docs.microsoft.com/en-us/powerquery-m/duration-days
=each Duration.Days([Date1] - [Date2])
Hi, you can find the solution in this post.
http://blog.iwco.co/2018/12/07/numero-de-dias-entre-dos-fechas-power-query-m/
Regards