Forum Discussion
IRR with dynamic measures
Pbix file: https://ufile.io/8lsvjz9t Hi guys! Could you help me out with one Internal Rate of Return (IRR) question, please? The funcionality that I'm seeking is the following one: I have three a...
Basically, if I could get a calculated table with "Financial Data[Asset]" on one column, then "Years" values (going from 2022 to 2028 / or an INDEX going from 1 to 7) for every asset: like this:
ASSET1 - 2022
ASSET1 - 2023
ASSET1 - 2024
...
ASSET1 - 2028
ASSET2 - 2022
...
Then I think I would just need to create a formula which says "for 2022 rows, assign the [CF 2022] for that Asset" and "for 2023 rows, assign the [CF 2023] for that Asset", and so on. After that I would have three columns: Asset, Year and Cash Flow by Year and then I think I could just use the XIRR formula perhaps. What do you think?