DATEDIFF

« Back to Glossary Index

Syntax

DATEDIFF(<start_date>, <end_date>, <interval>)

Tutorial with example

EXAMPLE 1

In today’s video, I will show you how to calculate the difference between two dates using DATEDIFF.
I also show you how to overcome the issue when the start date is larger than the end date.

Link to Northwind dataset: https://www.youtube.com/watch?v=k3NMIlLffrU

Link to DAX Switch: https://www.youtube.com/watch?v=-ykkaAtlCMc

Download example file:

Link to demo file here.

EXAMPLE 2

In today’s video we will deconstruct a measure that was created by a microsoft employee in the Power BI community:

Link to the Power BI community post: https://community.powerbi.com/t5/Desktop/Calculate-duration-based-on-dates-in-different-rows/td-p/58886

In this video we will go also through the functions:
05:56 LOOKUPVALUE
09:12 DATEDIFF and
How to calculate the difference between two dates in the same column in Power BI.

Remarks

An error is returned if start_date is larger than end_date.

« Back to Index