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

Sure, it is achievable, if you share the excel file with formulas you have, will work out something, 

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.