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.

Raj12's avatar
Raj12
Helper III
4 years ago

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?

 

  • Raj12's avatar
    Raj12
    Helper III
    4 years ago

    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