Forum Discussion
Solved
Dateadd interval by numerical column
Hi all, I have a form that I am trying to graph in Power BI. The form contains a start date field (Date Selector) and a numerical entry field called Amortization for the duration and I would like to...
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?