Forum Discussion

Raj12's avatar
Raj12
Helper III
4 years ago
Solved

Implementing Excel table in Power Bi where a column value depends on another column earlier value

I want to implement an excel table in Power Bi Ideally I have 1st column data i.e. for year 30th and rest all should populate based on calculation:   Year 30 31 32 33 34 35 36 37 38 3...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Share the source data (not the expected result which you have pasted in the original message) in a format that can be pasted in an MS Excel file.

Raj12's avatar
Raj12
Helper III
4 years ago

This is source data is 

AgeContributionInvestment Growth Fund Value 
302500502550


Now have to calculate forecasting for further Age yrs i.e. 31,32,33 etc based on calculation that

Growth = ( This year contribution+Earlier year fund value ) * 0.02
Contribution is constant for all years

Fund Value = This year contribution + Earlier year fund value+ This year Inv growth