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
Hey marcmen ,
please provide a pbix that contains some sample data. Upload the pbix to onedrive or dropbox and share the link. Describe the expected result based on the sample data you provided.
Regards,
Tom