Forum Discussion
Source data with new columns
You can change the Power query to replace the source. Do append extra columns in the TransformColumnTypes.
Or as easy as, import the new CSV as a new table, delete the original table and rename the new table. As long as the old column names exists, visuals would show correctly.
I tried adding a table and renaming it previously it didn't work (I also tried again just then too).
All the calculations I put in disappeared.
Similarly I previously tried changing the source in the Advanced Editor (though I didn't include the new variable with TransformColumnTypes). When I tried it again just then this time including the new variable in TransformColumnTypes, it also didn't work.
After I do my proof of concept presentation, I might try to replicate this with a small/simple dataset.
I have no idea on the calculations in your case, the approaches actually work with simple dataset in my test.