Forum Discussion
Dynamic Calculated Columns using What If Parameter
It can be only used in measures not in columns. You can add a measure for you date calculation and use that.
Thanks for hte response.
Unfortunately the remaining useful life for each row of data (each component) needs to be recalculated based on the user selected futrure date so I don't think I can make it work by only adding a measure for the date (I actually tried that but without being able to trigger a recalculation of the row data, it does nothing).
We are working with components that are installed on commercial aircraft that are leased into operators. What we need to do is to calculate the amount of remaining value each componet has when it is returned off lease. The "dynamic" component comes into play because the Lessor wants to be able to change the lease return date and see what impact the new date has on the remaining life of the components.
Here's a video of an Excel version of what I'm trying to do.
Sure, it is achievable, if you share the excel file with formulas you have, will work out something,