Forum Discussion

k-k-k-k's avatar
k-k-k-k
Frequent Visitor
5 years ago

Automatically adds computed columns

Hi experts, I hope the table can add calculate column by the self. It should be happen after refresh and the external data like config file will trigger it. is the action possible? thanks!

8 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    k-k-k-k , I doubt that is possible.

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • k-k-k-k's avatar
      k-k-k-k
      Frequent Visitor
      5 years ago

      Thanks for your reply! Is there any solution about that? I see hope.

      Example: Table A in PBI model. Actually, I just want do the actions of add column to Table A  by parameter change by refresh config file, don't need operation it in power query. Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI k-k-k-k 

    A table can add calculate column by the self after the dataset is loaded and a DAX formula is specified for it so that it knows what to add as a values in the column. It will happen for every refresh but external data like config file cannot trigger it.

    • k-k-k-k's avatar
      k-k-k-k
      Frequent Visitor
      5 years ago

      Thank you very much! 

      Just think about, whether M language can do it?  For PBI table structure extend can not be auto-complete by configurate external parameter? thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI k-k-k-k 

         

        "table can add calculate column by the self.It should be happen after refresh and the external data like config file will trigger it"

        Can you defile self? Either DAX or M need to come into play only after the daatset is loaded.

        Which config file? I am not aware of any config file on Power BI.

        There is no way "external data like config file" will trigger it.