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

     

TomMartens's avatar
TomMartens
Super User
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

 

  • marcmen's avatar
    marcmen
    Helper I
    4 years ago

    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. 

     

    • marcmen's avatar
      marcmen
      Helper I
      4 years ago

      TomMartens  - I just realized that the DAX provided does not add to the date  -  it duplicates the start date only. Any thoughts?