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!
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.

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

    Anonymous  Thanks, actualy the external config means data from files or other source. it's just data.  the action is drived by specific data's change when refresh. for example: when a number in source table changed from 1 to 2 , and after refreshed, the table in PBI will automantic add column . looks it is impossible.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi k-k-k-k 

      It is impossible for PBI to know the previuos state of data between dataset refresh.

       

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      5 years ago

      Hi , k-k-k-k 

      Do you mean  automatically adding a step (add a custom column) to M query once it detects a change in database data?

      If so, I'm  afraid that PowerBi doesn't support it currently.

      For your needs, you can try to post your ideas on the idea forum. But I think it may take a long time to implement this function.

      You can also ask the support team for further help, maybe they will have better suggestions

       

      Best Regards,
      Community Support Team _ Eason