- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@TomMartens - I just realized that the DAX provided does not add to the date - it duplicates the start date only. Any thoughts?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-27-2023 12:36 AM | |||
08-29-2023 08:35 PM | |||
Anonymous
| 05-23-2024 11:13 PM | ||
Anonymous
| 03-16-2023 09:51 AM | ||
09-03-2024 11:43 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |