Adding Number of Months to a Date

[Digger99]

Hi,

I am trying to add two different numbers to a date within my table using DAX. The date is when the product needs to be purchased 'First Order', i then want to add the Lead Time to this date 'LT' and then an additional 2 months to allow enough time for it to be shown in my account. The table looks like this:

First Order	LT (Months)
06/03/2023	10
09/03/2023	3
14/03/2023	5

Expected result would be - 06/03/2023 + 10 (LT) + 2 (Additional Months) = 06/03/2024

Any help will be greatly appreciated!!

Thanks.

[shreyamukkawar]

Hi,

new_clm = EDATE('Table'[First Order],'Table'[LT (Months)]+2)

Best Regards,
Shreya

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Digger99]

Hi Shreya,

Thanks for the response. I have tried EDATE but seem to get an error message "An argument of function 'EDATE' has the wrong data type or the result is too large or too small". 

Do you have anything else i could try?

[FreemanZ · Accepted solution]

hi @Digger99 

try to add a calculated column like:

Column =EDATE([First Order], [LT]+2)

[Digger99]

Thanks for the reply.

I have tried EDATE but i get the error message "An argument of function 'EDATE' has the wrong data type or the result is too large or too small". 

[FreemanZ]

hi @Digger99 

please check if the data type of [First Order] is date/time, [LT] is whole number.

[Digger99]

Can confirm that [First Order] is Date/Time - it was just date before but have changed to Date/Time. [LT] is a whole number.

[Digger99]

@FreemanZ I have just tried it another table and its been accepted. I think because i was using the EDATE function in a calculated table it was throwing an error up.

Thank you very much for the help, i will accept your comment as the solution!