How to copy a measure between two reports in Power BI?

Introduction

In this article, I am going to explain how to copy measures from one file to another file in Power BI.

Copy measure between 2 files became easy with tabular editor.

The developer needs to install the tabular editor tool for this. To download the tool click here .

Once it is installed you can find that under external tools.

Step 1: Open the two files

The two files are named here as V1 and V2. In the product table, we are going to copy the measure count of product from V1 to V2.

File V1
File V2

Step 2: Open tabular editor for each file.

Once you opened the tabular editor from the file named V1 and V2 user can find the measure and column details of the table.

File V1
File V2

Step 3: Copy-paste the measure

Select the measure user needs to copy using the CTRL button. Once the measures are selected we can copy and paste using CTRL+C and CTRL+V button.  

File V1
File V2

Many other analysis also can be done using tabular editor.

Author

  • DINESH KUMAR

    Tableau Certified Data Analytics professional with 7+ years of overall IT experience and 4 years of experience in analytics. Completed Post graduate program in Data science and Engineering from Great Lakes. Having good knowledge in Tableau, PowerBI, SQL and Python. Member of Data Visualization Society(DVS). Currently working as Data Analyst in Elsevier, a publishing and information analytics company.

2 thoughts on “How to copy a measure between two reports in Power BI?”

Leave a Comment

Your email address will not be published. Required fields are marked *