Year calculation for leap years

[Victormar]

Hello, community

I have a situation where I have contracted dates for vehicles, and I need to calculate the renovation date, which is after 6 months and after one year. The thing is that I have some vehicles with starting contracts on the 1st of March, therefore when I do a formula where I add a year to it, it can happen that the result is the 2nd (If I am not wrong, Power BI just adds 365 days to it, and I am guessing for shortened February years that is a potential problem).

This is my formula:

c_AnniversaryDate =

VAR six_months =

    DATE ( YEAR ( [Current year start date] ), MONTH ( DIM_Chassis[CONTRACT_START_DATE] ) + 6, DAY ( DIM_Chassis[CONTRACT_START_DATE] ) )

VAR twelve_months =

    DATE ( YEAR ( [Current year start date] ) + 1, MONTH ( DIM_Chassis[CONTRACT_START_DATE] ), DAY ( DIM_Chassis[CONTRACT_START_DATE] ) )

RETURN

    IF (

        [Current year start date] < TODAY ()

            && TODAY () > six_months,

        twelve_months,

        six_months

    )

Does anybody know how to solve that scenario?

Thanks in advance for your time 🙂

[Victormar]

thanks! that worked really good!

[danextian · Accepted solution]

Hi @Victormar 

Instead of adding a 1 to the year or 6 to the month, why not just use EDATE?  EDATE ( DATE (2024, 3, 1), 18 ) is DATE (2025, 9, 1) which is 18 months after the original date. Or if you want the date 18 months prior, just use -18.
March 1, 2024 becomes