Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
mmh
Helper I
Helper I

same repoort with different join(merge) in same dataset

Hi,

I have one report where dataset need to to merge two ways, ie. left join with  one column  and another join with same datset, same tables but within 3 columns. is it posible to make it within one report or need to generate two report.

 

Thanks

MMH

1 ACCEPTED SOLUTION
Adamboer
Responsive Resident
Responsive Resident

Yes, it is possible to merge two ways within one report. You can achieve this by using Power BI's merging and joining capabilities.

Here are the steps you can follow to merge the dataset in two ways:

  1. Import the dataset into Power BI.

  2. Select the "Modeling" tab and then click on "New Table" to create a new table.

  3. In the formula bar, enter the formula for left join with one column. For example, if you want to left join Table1 with Table2 on the "ID" column, the formula would be:

    LeftJoinTable = LEFT JOIN(Table1, Table2, "ID")

    Create another new table, and in the formula bar, enter the formula for the second join. For example, if you want to inner join Table2 with Table1 on the columns "ID", "Date", and "Product", the formula would be:

    InnerJoinTable = INNER JOIN(Table2, Table1, {"ID", "Date", "Product"})

    By following these steps, you should be able to merge your dataset in two ways within one report.




    You can now use the "LeftJoinTable" and "InnerJoinTable" in your report as needed.

View solution in original post

4 REPLIES 4
Adamboer
Responsive Resident
Responsive Resident

Yes, it is possible to merge two ways within one report. You can achieve this by using Power BI's merging and joining capabilities.

Here are the steps you can follow to merge the dataset in two ways:

  1. Import the dataset into Power BI.

  2. Select the "Modeling" tab and then click on "New Table" to create a new table.

  3. In the formula bar, enter the formula for left join with one column. For example, if you want to left join Table1 with Table2 on the "ID" column, the formula would be:

    LeftJoinTable = LEFT JOIN(Table1, Table2, "ID")

    Create another new table, and in the formula bar, enter the formula for the second join. For example, if you want to inner join Table2 with Table1 on the columns "ID", "Date", and "Product", the formula would be:

    InnerJoinTable = INNER JOIN(Table2, Table1, {"ID", "Date", "Product"})

    By following these steps, you should be able to merge your dataset in two ways within one report.




    You can now use the "LeftJoinTable" and "InnerJoinTable" in your report as needed.
mmh
Helper I
Helper I

can you share idea please

Ehren
Microsoft Employee
Microsoft Employee

In addition to what Adamboer suggested, you can also do this in Power Query if you'd like to do the joins before loading to the model.

  • Start with your two queries (Table1 and Table2) in the Power Query Editor
  • Select Table1, and then from the Home ribbon choose Merge -> Merge Queries as New
  • Enter the settings for your first join and click OK
  • Select Table1 and once again click Merge Queries as New
  • Enter the settings for your second join and click OK
Ehren
Microsoft Employee
Microsoft Employee

Yes, you should be able to do this in one report.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.