Forum Discussion

wrwillits's avatar
wrwillits
Helper III
8 years ago
Solved

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 ...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    It can be only used in measures not in columns. You can add a measure for you date calculation and use that.

  • parry2k's avatar
    parry2k
    8 years ago

    here is the link to pbix

     

    Feel free to change calcs as you see fit. all the measure starts with x are the calculated measures.

     

    All there is paramter for path of excel file which you can change to point to you excel file.

     

     

wrwillits's avatar
wrwillits
Helper III
8 years ago

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.

Dynamic row re-calculation

parry2k's avatar
parry2k
Super User
8 years ago

Sure, it is achievable, if you share the excel file with formulas you have, will work out something,