Forum Discussion

erickparra's avatar
erickparra
Frequent Visitor
8 years ago

How to duplicate "Calculated Table"

Hi Gurus!,   I need to duplicate a calculated table, where I have maybe 30 calculated columns. I need to create the same table but with little differences (Little changes on DAX). Then I do not wan...
Need Help
SWegener's avatar
SWegener
Regular Visitor
6 years ago

Hi,

how about the following approach?

 

  1. Create a new calculated table.
  2. Insert the following line into the editor:
    CopyOfMyCalculatedTable = MyCalculatedTable

  3. Adjust the DAX expressions in table CopyOfMyCalculatedTable according to your needs.

 

Greetings

SW

 

erickparra's avatar
erickparra
Frequent Visitor
6 years ago

Hi,

 

Thanks for your time, but duplicate the same table is not the solution to the given problem.

I mean to create a new indepent table keeping the same formulas for every column based in other calculated table.

 

In other words, to create a new calculated table with several columns for similiar task. I need to copy column by column formulas.

 

Regards,

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    6 years ago

    erickparra 

     

    I think what SWegener  and parry2k  were referring to was to use DAX to duplicate the table.

    See this example:

     

    And then the Duplicate:

     

    OR, you can copy the DAX from the Calculated table and alter the output directly in the DAX, as in:

     Where I've changed the caculation ouputs in each column

     

    If however you need to change the DAX in calculated columns included in a calculated table then I'm out of ideas, except the good old copy and paste.

     

    Just out of curiosity, why the need to duplicate a table and alter some DAX? can't you use measures instead?