Forum Discussion
Need to create interdependent measures
Hi! I'm new to DAX measures - any help would be greatly appreciated! I need to calculate beginning and ending balances of a saving plan account. Thing is, they are dependent on each other. I was able...
Hi Ashish! Thank you for replying!
Please see the excel workbook here containing calculations.
Sasank
I would like to add a few more things here -
- all components used in this calculation are measures. I couldn't have them as calculated columns as their calculations depend on numeric range parameters which are entered at runtime in the dashboard.
- The main issue here is that the beginning balance depends on ending balance from prior year and the ending balance depends on beginning balance of the current year.
I hope this clears up my calculation a bit. Thanks!