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

 Happy to share the Excel example but not sure how to attach a file to the message (no file attachment capability that I can see).

parry2k's avatar
parry2k
Super User
8 years ago

wrwillits you cannot attach, share it thru google drive or other preferred way.

    • 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