Forum Discussion

Consultant001's avatar
Consultant001
Frequent Visitor
8 years ago
Solved

Create a duplicate date table

Hi everyone

 

How do I duplicate a date table if I don’t have access to edit queries?

 

I have a date table, however, I want to make a duplicate date table (second date table) so that I can link two different relationships.

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Consultant001,

     

    You can try to use dax formula to create a calculate table based on current table.(New table=Old Table)
    Notice: use dax function to duplicate table not works on directquery and live connection mode.

     

    Regards,

    Xiaoxin Sheng

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Consultant001,

     

    You can try to use dax formula to create a calculate table based on current table.(New table=Old Table)
    Notice: use dax function to duplicate table not works on directquery and live connection mode.

     

    Regards,

    Xiaoxin Sheng

  • davehus's avatar
    davehus
    Memorable Member
    8 years ago
    Using Summarize to create a second table could be an option.
  • prateekraina's avatar
    prateekraina
    Memorable Member
    8 years ago

    Hi Consultant001,

     

    I think you are connected live to a Power BI Dataset. If that is the case you cannot create a duplicate table.

     

    Prateek Raina