Link to home
Start Free TrialLog in
Avatar of angelfromabove
angelfromaboveFlag for United States of America

asked on

Dynamic CAGr in PowerBi

I need to calculate CAGr by our Fiscal Year (which starts in November) for balances for several different accounts based on the open (beginning) date of the account.

For example account A opened November 25, 2015, Account B opened June 2, 2009, Account C opened February 15, 2019. The Fiscal year begins in November of each year

Not sure if this is relevant, but the balances are already cumulative; i.e. the balance for the most current month is the sum total of all previous months/years.

If an account doesn't have a full year's history, I'd like it to be able to pro-rate CAGr based on the month we're currently in.

I have a table already set up for fiscal years, but it's in a different table than my accounts and balances and open dates. The tables are linked, so not sure if that even makes a difference.  

Ultimately, I need to be able to select an account based on a slicer or some other filter (I already have set up); it should then calculate the CAGr in a card or table visual based on the selected account.  Behind the scenes, it should also know the beginning dates of each account (which is used to calculate CAGr).    

Unfortunately, I can't send a sample file due to the confidentiality of the data, but hoping this is fairly intuitive the way I've explained it here. Thanks in advance for your assistance!
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.