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.

 

 

swatiupadhyaya's avatar
swatiupadhyaya
New Member
8 years ago

this is very elaborate and helpful.

Although i am trying to do the same with a a range of decimal values instead of date i.e.

a what if paramter created threshold -  0 to 1 with increment 0.1.

my calculated field

x threshold_test2 = if(HASONEVALUE(thresh_test_2[threshold]),VALUES(thresh_test_2[threshold]),0.5) always returns the default 0.5 even if you select any other data from splicer.

 

Can you please help.

 

Thanks