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

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.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

parry2k 

Unable to access to the pbix file, can you reshare it