DATEDIFF DAX Function in Power BI
The DATEDIFF DAX function in Power BI returns the number of interval boundaries between two dates.
DAX Syntax DATEDIFF(start_date, end_date, interval)
The function has the following parameters:
- start_date: The starting date (column, measure, or expression).
- end_date: The ending date.
- interval: The unit of time to calculate the difference.
We can use the following keywords for interval:
| Interval | Description | 
|---|---|
| SECOND | Difference in seconds | 
| MINUTE | Difference in minutes | 
| HOUR | Difference in hours | 
| DAY | Difference in days | 
| WEEK | Difference in weeks | 
| MONTH | Difference in months | 
| QUARTER | Difference in quarters | 
| YEAR | Difference in years | 
Example: Calculate the Difference in Year.
DAX
DATEDIFF Measure = 
    DATEDIFF(
        DATE(2022, 4, 12), 
        DATE(2025, 6, 25), 
        YEAR
    ) The output of the above code is 3.
Example: Calculate the Difference in Quarter.
DAX
DATEDIFF Measure = 
    DATEDIFF(
        DATE(2022, 4, 12), 
        DATE(2025, 6, 25), 
        QUARTER
    ) The output of the above code is 12.
Example: Calculate the Difference in Months.
DAX
DATEDIFF Measure = 
    DATEDIFF(
        DATE(2022, 4, 12), 
        DATE(2025, 6, 25), 
        MONTHS
    ) The output of the above code is 38.
 Note:  • If end_date is earlier than start_date, result will be negative. 
 • Works with columns and measures. 
Example: Calculate the Difference in Months, this time the result is -38.
DAX
DATEDIFF Measure = 
    DATEDIFF(
        DATE(2025, 6, 25), 
        DATE(2022, 4, 12), 
        MONTHS
    ) The output of the above code is -38.