Add a number of months to a date

[Syndicate_Admin]

Hello Community!

I would like to add a number of months to a date to get a target date. (A) execution Period + (B) Start Date = End Date.

Thanks a lot

[Samarth_18 · Accepted solution]

Hi @Syndicate_Admin 

YOu can create a column with below code:-

Column =
DATE ( YEAR ( 'Table'[B] ), MONTH ( 'Table'[B] ) + 'Table'[A], DAY ( 'Table'[B] ) )

Thanks,

Samarth