Forum Discussion
Dynamic Calculated Columns using What If Parameter
Can you use What If Parameters to dynamically recalculate a calculated column? I need to allow the user to change dates that are being used to forecast out component values. I currently have a fixed future date in each row of data for each component that I am using to forecast the future value for that componet (value deterorates over time), but the customer wants to make changes to that date on the dashboard and then immediately see the revised forecast based on the slected future date. I tried using a What If Parameter to allow the user to add days to the date (Fixed Date + Parameter days = New Future Date) but it won't recalculate the new date. I also tried a Refresh thinking that the system would recalculate the column vales if I refreshed the data but that didn't work either. Can Parameters only be used to filter a table or with Measures?
It can be only used in measures not in columns. You can add a measure for you date calculation and use that.
14 Replies
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.
parry2k wrote:It can be only used in measures not in columns. You can add a measure for you date calculation and use that.
Hi parry2k,
I encounter the similar issue, and also want to use the IF function in new column.
Could you tell me why it is not support in columns?
Thank you for your reply.
