Calculating future date from a date field and a term (1 year, 2 years, 3 years, etc..) field

[Quasae]

Hi all,

  Very new to BI and am trying to figure out a way to calculate a future date of Payment Due based of of a Purchase date and a Term.   Basically, I want to take the Purchase Date and then add to it Term * Year(s).  So if an item was purchased on 4/26/2023 and has a Term of 1, then the Payment Due Date for that item would be 4/26/2024.   I have tried for hours to get a measure work and have utterly failed.  There has got to be an easy way to do this.   Any help would be greatly appriciated.

[some_bih]

NextDue = DATEADD('2023'[Purchase Date],'2023'[Renewal Term],YEAR)

[Quasae]

I also tried that and still retuned no value.  I did get it working using EDATE().  See below.  I would still like to know why DATEADD() would not work.

NextDue = 
IF
    ('2023'[Renewal Term] > 0.00,
        EDATE (
                '2023'[Purchase Date] ,
                '2023'[Renewal Term] * 12
            )
    )

[some_bih]

It could be due to format of your column.

[some_bih]

@Quasae removal term is "year" for lasting guarantee or something. whatever it is remove INT in your formula, other part leave as is and check results.

[some_bih]

Hi @Quasae use function DATEADD

your column name = DATEADD(<your table name>[your column name], 1,year)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Quasae]

Hi @some_bih, 
  I have actually tried this but for some reason it never produces a value.  I have tried it with 

NextDue = DATEADD('2023'[Purchase Date],1,YEAR) and NextDue = DATEADD('2023'[Purchase Date],INT('2023'[Renewal Term]),YEAR). Neither of them return a value.