Forum Discussion
Circular Dependency in Power Bi calculated column
Hi Community, I have been trying all sort of tricks with DAX, but just cannot get to a solution to my challenge. Would appreciate some help. I am trying to create an investment schedule in the Po...
Hi lbendlin
We will also require Weighted Average NAV and daily changes column for further calculations.
NAV is value of each unit of investment. I am calculating weighted average NAV by dividing (Closing Investment) by (Closing no. of units).
lbendlin
Super User
Super UserI get rather different numbers:
"NAV cumul" shows the NAV of the remaining units after each transaction.