Forum Discussion

marcmen's avatar
marcmen
Icon for Helper I rankHelper I
4 years ago
Solved

Amortization Help

Hi all, I am hoping that someone can help me out. I am a bit of a noob when it comes to Power BI but because I have touched it once or twice, I was voluntold for this project. I am creating a financ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi marcmen ,

     

    Assum you have a column for the days that a project might need.

    Then you could directly add the days with the start date.

    Then use datediff function to get the years between start date and end date.

    Column 2 =
    var _years = DATEDIFF('Table'[start date],'Table'[Column],YEAR)+1
    return
    'Table'[value]/_years

    If I misunderstand your meaning, please share some sample data and expected result.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi marcmen ,

 

Assum you have a column for the days that a project might need.

Then you could directly add the days with the start date.

Then use datediff function to get the years between start date and end date.

Column 2 =
var _years = DATEDIFF('Table'[start date],'Table'[Column],YEAR)+1
return
'Table'[value]/_years

If I misunderstand your meaning, please share some sample data and expected result.

 

Best Regards,

Jay

  • marcmen's avatar
    marcmen
    Icon for Helper I rankHelper I
    4 years ago

    Anonymous  - sorry for the delay with my response. I opted to create a calculated column in the source SharePoint list so I have not tried your solution. all I was looking to do was Date + Number from column  = new date. 

    I will try your solution as soon as I have a few minutes.