Forum

Formula in Power Qu...
 
Notifications
Clear all

Formula in Power Query

2 Posts
2 Users
0 Reactions
77 Views
(@kvmitchellpegmail-com)
Posts: 6
Active Member
Topic starter
 

Good day to all

Can Power Query insert a column that contains a formula that will reference sources elsewhere in the workbook? Similar to VBA's .Formula expression?

IE once the data has been queried and loaded into a table, the formula that was inserted in the query then uses other references that are in the workbook.

 
Posted : 26/06/2021 6:23 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Keith,

Only if you import that data into Power Query as a separate query.

Mynda

 
Posted : 27/06/2021 6:29 am
Share: