cancel
Showing results for
Did you mean:
Helper IV

## Convert days to year

Hi

I used this code to calculate the difference between 2 dates

Duration.Days(Duration.From([Date_Today]-[Date]))

This gives me the proper result in days, but can I convert these days into years?

so that ex 65 days  = 0 years, 521 = 1 year ...

thx

1 ACCEPTED SOLUTION
Super User

@jochendecraene

Your formula will go as :

``````Number.RoundDown(
Duration.Days(Duration.From([Date_Today]-[Date]))/365.25,
0
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up
3 REPLIES 3
Super User

@jochendecraene

Your formula will go as :

``````Number.RoundDown(
Duration.Days(Duration.From([Date_Today]-[Date]))/365.25,
0
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper IV

@Fowmy Thx

Can you just explain how the formula works?

Thnx!

Super User

@jochendecraene

First, calculate the days difference as oer your formula,
Divide it by 365.25 (.25 added to include leap year as it comes once in 4 years), you get the year with fraction.
Round it down to show only full completed year(s).

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors