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.

     

     

parry2k's avatar
parry2k
Super User
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.

wrwillits's avatar
wrwillits
Helper III
8 years ago

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).