Forum Discussion
NKrichmond
4 years agoFrequent Visitor
Need Help Calculating Book Value (Adjusted Cost Base) of Investments
Hi there. I am modernizing some Excel databases and am having some problems with DAX. I need a calculated column or a measure that will calculate the change in book value (adjusted cost base) for eac...
NKrichmond
4 years agoFrequent Visitor
Thanks Milan, that formula works well and solves the account instance issue I was having. However, the main issue I am having remians: the book value is not calculating properly and I am getting a circular dependancy error whenever I try to calculate it. This is because the book value calculation for redemptions depends on the previous BVPS, which depends on earlier ending book value calculations. Do you know if there is any way to get around this?
milanpasschier2
Helper I
4 years ago- Hey, probably, will check it tomorrow 😀