Forum Discussion

marcmen's avatar
marcmen
Helper I
4 years ago
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...
Need Help
  • TomMartens's avatar
    TomMartens
    4 years ago

    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

     

MarcMendez's avatar
MarcMendez
New Member
4 years ago

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