I am trying to keep the formulas in the tables I'm using after using power query. I've noticed that every time I load any table into power query, all the formulas get erased. Is there anyway to keep the formulas after using power query editor?
0
votes
1 Answers
2
votes
Unfortunately, no, this isn't possible. Power Query will wipe them out every time. It's been brought up and my understanding is there is currently no plan to change this functionality. The sister functionality of standard queries returning to Tables will honor your formulas. It's a little confusing why some do and some don't.
I recommend putting those formulas in the query itself, or use a tertiary Table for your calculation(s).
