Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@jochendecraene
Your formula will go as :
Number.RoundDown(
Duration.Days(Duration.From([Date_Today]-[Date]))/365.25,
0
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@jochendecraene
Your formula will go as :
Number.RoundDown(
Duration.Days(Duration.From([Date_Today]-[Date]))/365.25,
0
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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).
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.