topic Re: Adding Number of Months to a Date in DAX Commands and Tips

Adding Number of Months to a Date

Digger99 — Mon, 06 Mar 2023 10:48:58 GMT

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.

Re: Adding Number of Months to a Date

FreemanZ — Mon, 06 Mar 2023 10:55:34 GMT

hi Digger99

try to add a calculated column like:

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

Re: Adding Number of Months to a Date

Digger99 — Mon, 06 Mar 2023 11:02:12 GMT

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".

Re: Adding Number of Months to a Date

Anonymous — Mon, 06 Mar 2023 11:04:37 GMT

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!

Re: Adding Number of Months to a Date

FreemanZ — Mon, 06 Mar 2023 11:05:09 GMT

hi Digger99

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

Re: Adding Number of Months to a Date

Digger99 — Mon, 06 Mar 2023 11:10:38 GMT

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

Re: Adding Number of Months to a Date

Digger99 — Mon, 06 Mar 2023 11:15:43 GMT

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?

Re: Adding Number of Months to a Date

Digger99 — Mon, 06 Mar 2023 11:23:50 GMT

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!