Create a duplicate date table

[Consultant001]

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!

[prateekraina]

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

[v-shex-msft · Accepted solution]

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]

Using Summarize to create a second table could be an option.