cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 8
Highlighted
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Champion
Community Champion

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.


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted

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!

Highlighted

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!

Highlighted

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.


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted

@pranit828  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.

Highlighted

Hi @k-k-k-k 

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

 


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors