How To Calculate Difference Between Two Dates In Power Bi

by

To calculate the difference between two dates in Power BI, you can use the DATEDIFF function.

The syntax of the DATEDIFF function is as follows:

  DATEDIFF( start_date, end_date, interval )

The start_date and end_date parameters should be of type Date or DateTime. The interval parameter specifies the unit of time you want to calculate the difference in, such as days, months, or years.

Example:

Let’s say you have a table with two date columns: “StartDate” and “EndDate”. You want to calculate the number of days between these two dates.

  | StartDate  | EndDate    |
  |------------|------------|
  | 2021-01-01 | 2021-01-05 |
  | 2021-02-10 | 2021-02-15 |
  | 2021-03-20 | 2021-03-25 |

Here’s how you can calculate the difference in Power BI:

  Difference = DATEDIFF(TableName[StartDate], TableName[EndDate], DAY)

This formula will return the number of days between the StartDate and EndDate columns. The result will be a new calculated column in the table.

If you want to calculate the difference in months or years, you can change the interval parameter to MONTH or YEAR, respectively.

  DifferenceInMonths = DATEDIFF(TableName[StartDate], TableName[EndDate], MONTH)
  DifferenceInYears = DATEDIFF(TableName[StartDate], TableName[EndDate], YEAR)

Make sure that your date columns are formatted as Dates or Date/Time in Power BI, otherwise the DATEDIFF function may not work correctly.

Same cateogry post

Leave a comment