How to Insert Calculated Column in existing worksheets

[vv132]

Hey, I am trying to learn power pivot and came across and issue that I can’t figure out. After using power pivot to create and populate a calculated column between two tables(or work sheets) which power pivot is extremely helpful, I cannot figure out a way to export that calculated column into the/an excel worksheet. There is no option or button for it or exporting. And when I copy and paste it doesn’t not allow me to paste values which therefore causes me to lose some data. IS there any simple way to take the calculated column and insert it into the existing worksheet, or into a new worksheet without losing any values or data?

Any links on exporting calculating column information. I feel like this is crucial for a lot of analysts

Thanks
V

 

[scottsen]

Typically, you are going to be creating a pivot table to visual the results (or a pivot chart). It's not very often I want to pull ALL the results from power pivot back into a sheet in excel. I'm not even sure it's possible in 2010. In 2013, ... it's still a bit tricky.

 

[ImkeF]

If one regards Power Pivot as the little brother of Analysis Service in SQL-Server (SSAS), I’d translate your request for what analysts also need is an ETL-Tool on the self-service side. And it’s there: Power Query.

PP and SSAS are optimized for speedy aggregation of data and the multidimensional output of them – therefore the Pivot-Table as the standard output is a good choice. But if it comes to calculation values that might also be used elsewhere, I'd classify this more as an ETL-task, for which PQ lends itself to. There the standard output is a table.

Both tools have their strengths and each of them can do things that the other can also do. Which is good sometimes, because you don’t need to switch tools, but this also carries the risk of overstretching.