Copy and paste table with DAX on a PBI report?

[Anonymous]

Hi Everyone,

I have been working on a report where there is a need to copy a table along with all its DAX measures and columns and paste it on the same report. 

I have tried duplicate table using edit query but it won't bring the DAX.

I have tried copy table in the Data view but it is giving exception. 

Please suggest an efficient way where I do not have to copy every individual DAX on the table? 

Thank you! 

[Pragati11]

Hi @Anonymous ,

I fear there is no way to copy DAX calculations in Power BI along with data.

- Edit Query doesn't give us access to DAX calculations

- Data View doesn't export data with DAX calculations.

If the requirement is you want this table with all DAX calculations on other Power BI report, try copying the Power BI .pbix file as a new one and then use it. I can't think of any other way.

If this is helpful give Kudos, if resolves the issue mark it as a solution! 🙂

Thanks,

Pragati

[amitchandak]

In Data view have tried following

table = Old table

Table =distinct(Ole table)

Table = selectcolumns(Table,"Col1",table[Col1],"Col2",table[Col2])

Table = summarize table(Table,table[Col1],table[Col2])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[Anonymous]

@amitchandak  Hi there, I tried your suggestion on a Data View and it gives 'unexpected exception occured'. 

[amitchandak]

If the solution given by @MFelix  does not work then If possible please share a sample pbix file after removing sensitive information.Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[MFelix]

Hi @Anonymous ,

Check the post below

https://exceleratorbi.com.au/copy-measures-between-2-power-bi-files/