Forum Discussion
Implementing Excel table in Power Bi where a column value depends on another column earlier value
Its a great solution, just one thing:
Measure for **Contri = SUM(Data[Contribution])** which will add in all contribution in the data but my data has only 1st row contribution in there i.e. for today
| Age | Contribution |
| 30 | 1174 |
like below (from your file table: Data )only 1st row data is present and not for all upcomming years and can't create all years contribution in that table as there are more than 1million individual records for which I want this forecasting
| Contribution | Date |
| 1174 | Tuesday 1 January 2030 |
Hi,
I know of a way to explode that 1 row into 8 rows but that would mean giving rise to 8 million rows from your original dataset of 1 million rows. I dont think my solution will work efficiently there. Sorry but i cannot help here.
Thank you for your response.
Can't we take **Contri** measure as given value for each unique record and use it for calculating forecasting for other subsequent years as for other years **Contri* will remain same.
I do not know of a way to do that.
Okay and how can we get sum of a measure in there like if I take Fund value in a card visual then it shows only the last value not the sum of all the rows for fund value as shown below