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?