Forum Discussion
Implementing Excel table in Power Bi where a column value depends on another column earlier value
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
Write this measure
Measure = if(HASONEVALUE('Calendar'[Year]),[Fund value],SUMX(VALUES('Calendar'[Year]),[Fund value]))Thank you so much for the help .
You are welcome.
Jus one small thing.
I am trying to add in some initial fund value value in first year fund value only and subsequent calculation is as it is. Is it spossible?Tried to update existing meausre of Fund Value as:
Fund Value__ =
var val = [Inv till date__]+[Inv grwoth till date__]
return
if([Years elapsed]=1,val+SUM('Data'[Inital Fund]),val)
but it just adds in initial fund column value in 1st row but subsequent rows calulcation is not taking that added in value