Forum Discussion
Dateadd interval by numerical column
Hey MarcMendez ,
I do not fully understand the structure of the table "", but you can use the below DAX to create a calculated column:
Amortization End Date = DATEADD( 'AOP'[Project Start Date] , 'AOP'[Hardware Amortization (Months)] , MONTH )Based on the sample data the following screenshot shows the result:
Hopefully, this helps to tackle your challenge.
Regards,
Tom
Hey MarcMendez ,
I do not fully understand the structure of the table "", but you can use the below DAX to create a calculated column:
Amortization End Date =
DATEADD( 'AOP'[Project Start Date] , 'AOP'[Hardware Amortization (Months)] , MONTH )Based on the sample data the following screenshot shows the result:
Hopefully, this helps to tackle your challenge.
Regards,
Tom
TomMartens -thank you for this. You cannot understand the table structure because there is none 😁. This PBX is a brain dump at the moment - I need to rebuild it.
TomMartens - I just realized that the DAX provided does not add to the date - it duplicates the start date only. Any thoughts?