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.

Hawk_Wang's avatar
Hawk_Wang
Regular Visitor
7 years ago
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.