Forum Discussion
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 calculate an end date (months) based on that number. My issue is that I cannot figure out how to get DATEADD to accept the values from the Amortization field.
Any help would be appreciated
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
5 Replies
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
TomMartens - thanks for the response.
The PBX can be found here Annual Operating Plan Dashboard Draft.pbix
At this time, I am looking to be able to calculate an end date for the amortization fields. For example
[Project Start Date] + [Hardware Amortization (Months)] = Amortization End Date.
[Hardware List Price] / [Hardware Amortization (Months)] = Monthly Cost
Once I have the end date, I plan on duplicating the process for each amortized category, hopefully allowing me to create year-end rollups and a schedule based on another article I have read.
I appreciate your help
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?
