Dax formula disappears when refresh data

I assume for the refresh you have to edit the query is that correct? it's a bit annoying property of Excel, that after you edit a query all the DAX measure disappear

the solution is to create a measure specific table where you will store the measures, e.g. like this:

the other benefit is that if you hide all the columns in that table then measures will show on the top of the field list

in case you need to use calculated columns the only option is to change the query in a way that doesn't require changes with the data refresh, e.g. extracting from all files from a folder rather than single file, etc., or adding new columns in Power Query so that they're added with every refresh