Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Power Pivot: Copy Paste a Table in a PowerPivot does not copy-paste's the Formula's

Oct 17 2012 12:00AM by Paras Doshi   

I just learned that when you copy-paste a Table in Power Pivot it does not copy-paste the formula's. It just paste's the data in the target table. I just learned that when I was testing the Power Pivot model before emailing the client.

Read More..   [32134 clicks]

Published under: Power Pivot Tips · Business Intelligence Tips · General Technology Tips ·  · 


Paras Doshi
17 · 10% · 3265
4
 
0
Knew
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

7  Comments  

  • Try right-clicking and selecting "Paste Formulas". It has a little Fx logo.

    commented on Oct 18 2012 10:43AM
    Marc Jellinek
    95 · 2% · 586
  • @Marc: Thanks for the comment. Before posting this, I had searched for "paste formulas" in PowerPivot - I didn't find it. May be, I am missing something. I know such functionality is available in Excel but "paste formulas" does not seem to be supported when copy-pasting entire tables.

    commented on Oct 19 2012 4:10PM
    Paras Doshi
    17 · 10% · 3265
  • OK, here's what I've done.

    I created a PowerPivot based on the following query against a SQL Server 2008 R2 instance:

    SELECT
        [mf].[database_id], 
        [mf].[file_id], 
        [mf].[file_guid], 
        [mf].[type], 
        [mf].[type_desc], 
        [mf].[data_space_id], 
        [mf].[name], 
        [mf].[physical_name], 
        [mf].[state], 
        [mf].[state_desc], 
        [mf].[size], 
        [mf].[max_size], 
        [mf].[growth], 
        [mf].[is_media_read_only], 
        [mf].[is_read_only], 
        [mf].[is_sparse], 
        [mf].[is_percent_growth]
    FROM
        [master].[sys].[master_files] [mf]
    

    Within PowerPivot, I created two calculated columns:

    SizeMB =([size] *8) / 1024 Drive = =LEFT([physicalname], 1)

    What are you trying to copy-and-paste, using this scenario?

    commented on Oct 19 2012 5:34PM
    Marc Jellinek
    95 · 2% · 586
  • @Marc: Thanks for following up. Here's what I was doing:

    I am copy pasting the entire table along w/ calculated columns.

    Let me explain more, I was working was two PowerPivot models in parallel and both of them needed a "Date Table". I worked on a Date Table in one of the Model and then copy-pasted that in the other PowerPivot model. Later I realized that the the new Date Table was "Static" and it had lost all the business rules that I had created in my original date table.

    commented on Oct 19 2012 6:47PM
    Paras Doshi
    17 · 10% · 3265
  • I don't believe you can copy-and-paste calculated columns in the manner you did it. You'll have to create the calculated column in the target PowerPivot by copy-and-pasting the DAX query, not the data.

    commented on Oct 21 2012 4:28PM
    Marc Jellinek
    95 · 2% · 586
  • @Marc: Yes you're right - that's what I did. I copy pasted the DAX for each calculated column in the target table.

    commented on Oct 22 2012 10:56AM
    Paras Doshi
    17 · 10% · 3265

Your Comment


Sign Up or Login to post a comment.

"Power Pivot: Copy Paste a Table in a PowerPivot does not copy-paste's the Formula's" rated 5 out of 5 by 4 readers
Power Pivot: Copy Paste a Table in a PowerPivot does not copy-paste's the Formula's , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]