Is there way to copy whole table (with measures) into another table?

[JustinDoh1]

I have a Pbix file with one table that comprises of so many measures created after all (as shown below):

I am trying to copy the whole (table) into another table.

Is there anyway?

Thanks.

[parry2k]

@JustinDoh1 you can really take advantage of TE and advance scripting to copy the DAX measures and then change the reference to the table name in these measures to point to the new table and then execute the script. To learn more about scripting, you can check this TE page Advanced Scripting | Tabular Editor Documentation

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[v-yadongf-msft]

Hi @JustinDoh1 ,

Do you want to copy measures from one pbox file to another? If it is like this, please refer to: How to copy a measure between two reports in Power BI? (datacaffee.com)

If you want to copy measures between two tables in one report, I'm afraid there is no better way than manually copying the DAX.

However, here's an idea about copying measures in the following link, please vote it: Microsoft Idea (powerbi.com)

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@JustinDoh1 what is your definition of copying the table, just measures in that table or copy the table with all the data, and then redo those measures using the new table? Your question is very vague.

[JustinDoh1]

@parry2k 

Thank you for your reply.

I added all these measures into this particular table.

Now, I need to replicate all measures into a duplicated table (which comes from SQL View).

I guess replicating fields from SQL View is easy, but how to replicate measures?

[ribisht17]

@JustinDoh1 

See if it helps https://community.powerbi.com/t5/Desktop/Copy-and-Paste-Measures-into-another-table/m-p/258696

Thanks,

Ritesh